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` = 'Canyon Lake' OR `AddressCity` = 'Garden Ridge' OR `AddressCity` = 'McQueeney' OR `AddressCity` = 'New Braunfels' OR `AddressCity` = 'San Marcos' OR `AddressCity` = 'Seguin' OR `AddressCity` = 'Spring Branch')ORDER BY `AddressCity` ASC LIMIT 1950,75) p USING(`id`)ORDER BY `AddressCity` ASC

MLS® Property Listing Sitemap

4,185 Properties Found. Showing Page 27 of 56

New Braunfels

The information being provided by the Central Texas MLS is exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

The data is deemed reliable but is not guaranteed accurate by the MLS.

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 September 23rd, 2018 at 3: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.