infobar('Click on any Chula Vista property above to look at them in more detail');
?>
get_sid_boxes("Spring is here and summer is comming you're looking for a new home. Here are some beautiful homes that have their own pool or a pool in the community.","select L_ListingID from sd_paragon where $homesin and L_Type_='Detached' and LFD_Pool_25 <>'N/K' limit 7");
?>
get_sid_boxes("Condo's with a Pool","select L_ListingID from sd_paragon where $homesin and (L_Type_='All Other Attached' or L_Type_='Townhome') and LFD_Pool_25 <>'N/K' order by rand() limit 7");
?>
get_sid_boxes("Homes with five or more bedrooms!","select L_ListingID from sd_paragon where $homesin and L_Type_='Detached' and LM_Int1_3 >=5 order by rand() limit 7");
?>
Real Estate
Interested in selling your home on www.homes-in-lajolla.com? We can help you sell!
Contact Us