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  
8412 Redbird Street
Lenexa, Johnson, KS 66227
MLS: 1965376
Beds: 4 Baths: F 2 H 1 Status: Active
List Price: $333,800
go to detail

14101 ASPEN LANE
OLIVE BRANCH, DESOTO 38654
MLS: 298603
Beds: 5 Baths: F 4 H 0 Status: Active
List Price: $379,700
go to detail

  Showing 1 - 2 of 2