| All Listings | Over $1,000,000 |
string(4611) "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`.`ListingType` = 'Residential') AND `t1`.`ListingPrice` >= '1000000' AND ((`t1`.`AddressCity` = 'Calgary')) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC LIMIT 12,6) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Welcome To This Stunning Upper Elbow Park Residence, Featuring Over 5510 Sf Thoughtfully Curated By Veranda Estate Homes. Perfectly Situated On A Massive 75' Wide Lot, On A Lush Treed Lined Street. Exceptional Site Built & Finished Millwork, And L...
RE/MAX HOUSE OF REAL ESTATEMLS® #C4285745
Over 6000 Sq Ft Await You In This New Home Nestled In Upper Mount Royal, Located Minutes From The Best Amenities The City Has To Offer. Skilled Workmanship Abounds, From The Site Built Cabinetry, To The Nickel Hardware, & Masonry. The Main Level F...
RE/MAX HOUSE OF REAL ESTATEMLS® #C4279927
Modern & Sophisticated Custom Home W/ Smart Technology Designed By Stuart Howard Renowned Architect And Paul Lavoie Interior Design. Nestled Among Nature Amidst Mature Trees On A Quiet Street Of Prestigious Pump Hill. Built To Superior Standards T...
SOTHEBY'S INTERNATIONAL REALTY CANADAMLS® #C4288673
Enjoy The Video!modern Farmhouse Blends The Perfect Balance Between Traditional & Present-day Charm Combining A Functional Layout With Designer Finishes.with Over 7700sqft Of Luxuriously Appointed Living Space This Timeless Masterpiece Nestled In ...
CIR REALTYMLS® #C4290577
Available Fully Furnished, This Contemporary Masterpiece In Spring Valley Estates Offers More Than 6,300 Sq.ft Of Living Space With Panoramic Views Of Elbow Valley & The Rocky Mountains. Modern Design & Superior Craftsmanship Provide A Seamless In...
PLINTZ REAL ESTATEMLS® #C4247942
Rare Development Opportunity! Just Under 1 Acre (.8) "private" Treed Lot Backing Onto The 13th Tee Box Of The Calgary Golf And Country Club. This Lot Could Accommodate Up To 5 Luxury Bungalows, A Small Townhouse Development, A Lowrise Apartment C...
RE/MAX REAL ESTATE (CENTRAL)MLS® #C4265906
Disclaimer: Information herein deemed reliable but not guaranteed by CREB®.
Listing information last updated on July 13th, 2020 at 5:45pm MDT.