Sold History by Liz Ryan

string(1227) "SELECT SQL_CACHE `t1`.`link` AS 'ListingLink', `t1`.`title` AS 'ListingTitle', `t1`.`id` AS 'ListingMLS', `t1`.`mls_number` AS 'ListingMLSNumber', `t1`.`price` AS 'ListingPrice', `t1`.`type` AS 'ListingType', `t1`.`status` AS 'ListingStatus', `t1`.`description` AS 'ListingRemarks', `t1`.`address` AS 'Address', `t1`.`subdivision` AS 'AddressSubdivision', `t1`.`city` AS 'AddressCity', `t1`.`state` AS 'AddressState', `t1`.`zip` AS 'AddressZipCode', `t1`.`school_district` AS 'SchoolDistrict', `t1`.`school_elementary` AS 'SchoolElementary', `t1`.`school_middle` AS 'SchoolMiddle', `t1`.`school_high` AS 'SchoolHigh', `t1`.`bedrooms` AS 'NumberOfBedrooms', `t1`.`bathrooms` AS 'NumberOfBathrooms', `t1`.`bathrooms_half` AS 'NumberOfBathsHalf', `t1`.`squarefeet` AS 'NumberOfSqFt', `t1`.`garages` AS 'NumberOfGarages', `t1`.`yearbuilt` AS 'YearBuilt', `t1`.`lotsize` AS 'DescriptionLot', `t1`.`stories` AS 'DescriptionStories', `t1`.`features` AS 'DescriptionFeatures', `t1`.`latitude` AS 'Latitude', `t1`.`longitude` AS 'Longitude', `t1`.`virtual_tour` AS 'VirtualTour' FROM `_listings` `t1` JOIN (SELECT `t1`.`id` FROM `_listings` `t1` ORDER BY `price` DESC, `t1`.`id` DESC) p USING(`id`) ORDER BY `price` DESC, `t1`.`id` DESC"

4 Properties Found. Showing Page 1 of 1
Map
Sort by: