Connect

Deer Ridge Homes for Sale, $400,000 - $500,000

Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'Unknown column '' in 'where clause'
string(4671) "SELECT SQL_CACHE `t1`.`id` AS 'id', `t1`.`ListingMLS` AS 'ListingMLS', `t1`.`ListingPrice` AS 'ListingPrice', `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`.`ListingDOM` AS 'ListingDOM', `t1`.`ListingPriceOld` AS 'ListingPriceOld', `t1`.`ListingPriceChanged` AS 'ListingPriceChanged', `t1`.`TaxAmount` AS 'TaxAmount', `t1`.`CondoFee` AS 'CondoFee', `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`.`DescriptionSqFt` AS 'DescriptionSqFt', `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`.`ListingDOM` AS 'HiddenDOM', `t1`.`CondoFeeIncl` AS 'CondoFeeIncl', `t1`.`CondoFeePaySched` AS 'CondoFeePaySched', `t1`.`HasGarage` AS 'HasGarage', `t1`.`ListingAgent2ID` AS 'ListingAgent2ID', `t1`.`Zone` AS 'Zone', `t1`.`SiteInfluence` AS 'SiteInfluence', `t1`.`ListingQuadrant` AS 'ListingQuadrant', `t1`.`DescriptionFloor` AS 'DescriptionFloor', `t1`.`ListingPropertyManagement` AS 'ListingPropertyManagement', `t1`.`NumberOfUnits` AS 'NumberOfUnits', `t1`.`ListingFrontExposure` AS 'ListingFrontExposure', `t1`.`ListingFrontageMetres` AS 'ListingFrontageMetres', `t1`.`ListingPricePerSqFt` AS 'ListingPricePerSqFt', `t1`.`DescriptionBasementType` AS 'DescriptionBasementType' FROM `_rewidx_listings` `t1` JOIN (SELECT `t1`.`id` FROM `_rewidx_listings` `t1` WHERE `t1`.`ListingPrice` >= '400000' AND `t1`.`ListingPrice` <= '500000' AND (`t1`.`AddressSubdivision` = 'Deer Ridge') AND (`t1`.`` = 'Residential') AND ((`t1`.`AddressCity` = 'Calgary')) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Map Save this Search
Sort listings by:Price, High to Low

No listings were found matching your search criteria.

Disclaimer: Information herein deemed reliable but not guaranteed by CREB®.

Listing information last updated on July 12th, 2020 at 8:00am MDT.