SELECT `MLS_NUMBER` FROM `hrtres`.hrtres JOIN genkc.home ON `hrtres`.`MLS_NUMBER`=genkc.home.`home_mls` WHERE (L_OFF_ID LIKE '%GEN%') AND (home_hide = '0' OR home_hide IS NULL) AND (STATUS='Active') Generations Real Estate Incorporated
generations real estate home generations real estate aboutus generations real estate our listings mullin rentals contact generations real estate



go to map
 
 
 
 
  Showing 1 - 1 of 1  
5901 Longview Street
Shawnee, Johnson, KS 66218
MLS: 1844657
Beds: 4 Baths: F 3 H 1 Status: Active
List Price: $329,950
go to detail

  Showing 1 - 1 of 1