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 - 2 of 2  
6020 Longview Street
Shawnee, Johnson, KS 66218
MLS: 1907901
Beds: 4 Baths: F 2 H 1 Status: Active
List Price: $314,585
go to detail

20820 W 60th Terrace
Shawnee, Johnson, KS 66218
MLS: 1907895
Beds: 4 Baths: F 2 H 1 Status: Active
List Price: $312,950
go to detail

  Showing 1 - 2 of 2