SELECT SQL_CACHE `t1`.`id` AS 'id', `t1`.`ListingMLS` AS 'ListingMLS', `t1`.`ListingPrice` AS 'ListingPrice', `t1`.`ListingPriceOld` AS 'ListingPriceOld', `t1`.`ListingPriceChanged` AS 'ListingPriceChanged', `t1`.`ListingType` AS 'ListingType', `t1`.`ListingSubType` AS 'ListingSubType', `t1`.`ListingStyle` AS 'ListingStyle', `t1`.`ListingStatus` AS 'ListingStatus', `t1`.`ListingStatusOld` AS 'ListingStatusOld', `t1`.`ListingStatusChanged` AS 'ListingStatusChanged', `t1`.`ListingRemarks` AS 'ListingRemarks', `t1`.`ListingImage` AS 'ListingImage', `t1`.`ListingDate` AS 'ListingDate', `t1`.`Address` AS 'Address', `t1`.`AddressArea` AS 'AddressArea', `t1`.`AddressSubdivision` AS 'AddressSubdivision', `t1`.`AddressCity` AS 'AddressCity', `t1`.`AddressCounty` AS 'AddressCounty', `t1`.`AddressState` AS 'AddressState', `t1`.`AddressZipCode` AS 'AddressZipCode', `t1`.`SchoolDistrict` AS 'SchoolDistrict', `t1`.`SchoolElementary` AS 'SchoolElementary', `t1`.`SchoolMiddle` AS 'SchoolMiddle', `t1`.`SchoolHigh` AS 'SchoolHigh', `t1`.`NumberOfBedrooms` AS 'NumberOfBedrooms', `t1`.`NumberOfBathrooms` AS 'NumberOfBathrooms', `t1`.`NumberOfBathsFull` AS 'NumberOfBathsFull', `t1`.`NumberOfBathsHalf` AS 'NumberOfBathsHalf', `t1`.`NumberOfSqFt` AS 'NumberOfSqFt', `t1`.`NumberOfAcres` AS 'NumberOfAcres', `t1`.`NumberOfStories` AS 'NumberOfStories', `t1`.`NumberOfGarages` AS 'NumberOfGarages', `t1`.`NumberOfParkingSpaces` AS 'NumberOfParkingSpaces', `t1`.`NumberOfFireplaces` AS 'NumberOfFireplaces', `t1`.`YearBuilt` AS 'YearBuilt', `t1`.`HasPool` AS 'HasPool', `t1`.`HasFireplace` AS 'HasFireplace', `t1`.`HasBasement` AS 'HasBasement', `t1`.`IsWaterfront` AS 'IsWaterfront', `t1`.`IsForeclosure` AS 'IsForeclosure', `t1`.`IsShortSale` AS 'IsShortSale', `t1`.`IsBankOwned` AS 'IsBankOwned', `t1`.`DescriptionLot` AS 'DescriptionLot', `t1`.`DescriptionPool` AS 'DescriptionPool', `t1`.`DescriptionView` AS 'DescriptionView', `t1`.`DescriptionStories` AS 'DescriptionStories', `t1`.`DescriptionFireplace` AS 'DescriptionFireplace', `t1`.`DescriptionWaterfront` AS 'DescriptionWaterfront', `t1`.`DescriptionBasement` AS 'DescriptionBasement', `t1`.`DescriptionGarages` AS 'DescriptionGarages', `t1`.`DescriptionParking` AS 'DescriptionParking', `t1`.`DescriptionAmenities` AS 'DescriptionAmenities', `t1`.`DescriptionAppliances` AS 'DescriptionAppliances', `t1`.`DescriptionUtilities` AS 'DescriptionUtilities', `t1`.`DescriptionFeatures` AS 'DescriptionFeatures', `t1`.`DescriptionExterior` AS 'DescriptionExterior', `t1`.`DescriptionExteriorFeatures` AS 'DescriptionExteriorFeatures', `t1`.`DescriptionInterior` AS 'DescriptionInterior', `t1`.`DescriptionInteriorFeatures` AS 'DescriptionInteriorFeatures', `t1`.`DescriptionHeating` AS 'DescriptionHeating', `t1`.`DescriptionCooling` AS 'DescriptionCooling', `t1`.`DescriptionZoning` AS 'DescriptionZoning', `t1`.`DescriptionRoofing` AS 'DescriptionRoofing', `t1`.`DescriptionWindows` AS 'DescriptionWindows', `t1`.`DescriptionConstruction` AS 'DescriptionConstruction', `t1`.`DescriptionFoundation` AS 'DescriptionFoundation', `t1`.`DescriptionHOAFees` AS 'DescriptionHOAFees', `t1`.`DescriptionHOAFeesFrequency` AS 'DescriptionHOAFeesFrequency', `t1`.`ListingOffice` AS 'ListingOffice', `t1`.`ListingOfficeID` AS 'ListingOfficeID', `t1`.`ListingAgent` AS 'ListingAgent', `t1`.`ListingAgentID` AS 'ListingAgentID', `t1`.`Latitude` AS 'Latitude', `t1`.`Longitude` AS 'Longitude', `t1`.`VirtualTour` AS 'VirtualTour', `t1`.`ListingFeed` AS 'ListingFeed', `t1`.`ListingDOW` AS 'ListingDOW' FROM `v_hcroan_listings` `t1` JOIN (SELECT `t1`.`id` FROM `v_hcroan_listings` `t1` WHERE `AddressCity` IS NOT NULL AND `AddressCity` != '' AND (`AddressCity` = 'Boerne' OR `AddressCity` = 'Canyon Lake' OR `AddressCity` = 'Garden Ridge' OR `AddressCity` = 'Kingsbury' OR `AddressCity` = 'McQueeney' OR `AddressCity` = 'New Braunfels' OR `AddressCity` = 'San Marcos' OR `AddressCity` = 'Seguin' OR `AddressCity` = 'Spring Branch')ORDER BY `AddressCity` ASC LIMIT 0,75) p USING(`id`)ORDER BY `AddressCity` ASC

MLS® Property Listing Sitemap

4,920 Properties Found. Showing Page 1 of 66

Boerne

Canyon Lake

The data relating to real estate on this web site comes in part from the Internet Data Exchange program of the MLS of the San Antonio Board of Realtors®, and is updated as of June 19th, 2019 at 2:58pm CDT (date/time).

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.