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  
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 - 1 of 1