| 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 18,6) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Located In The Providence Asp 1 & Within Calgary City Limits, This 20 Acre Parcel Is Zoned S-fud. At This Time, It Is Forecast To Be Just South Of Future Lrt Station. Property Is North Of Spruce Meadows And Highway 22x, With Easy Access To The Rin...
RE/MAX REALTY PROFESSIONALSMLS® #C4292608
For More Info Click Multimedia - Top Property On Lake Bonaventure! Amazing Opportunity To Own A Lake Home In The City! Extensive/near Full Renovation Completed In 2019, A Must See. All New Electrical, Plumbing, Insulation, Appliances, Windows, Kit...
MY MOVE REALTYMLS® #C4303083
Come Build You Dream Home....fully Custom Homes...recommended Builders Or Bring Your Own Builder..... Welcome To This 4.8 Acre Private Oasis With A Huge Investment Opportunity With 11 Ravine Lots With 4 Ready To Go Ranging Is Size From Just 1/4 Of...
CENTURY 21 BAMBER REALTY LTD.MLS® #C4294594
Built Into The Streetscape Of A Quiet Tree-lined Street In Rideau Park, This Masterpiece By Empire Custom Homes Offers Superior Craftsmanship, Design, And Architecture. Beautiful Landscaping And Front Veranda Welcome You Inside. The Main Level, Wi...
PLINTZ REAL ESTATEMLS® #C4279211
*photos Are From Past Projects Of The Builder. Luxury Living At Its Finest By Exclusive Estate Builder Mairen Homes. No Expense Has Been Spared W/this Sophisticated 3-storey Designed W/function & Entertainment In Mind. Quality Craftsmanship & Opul...
RE/MAX REAL ESTATE (CENTRAL)MLS® #C4296102
Welcome To This Grand Upper Elbow Park Residence, Featuring Over 5460 Sf Classically Designed By Veranda Estate Homes. Perfectly Situated On A West Garden Lot, On One Of Elbow Park's Best Streets. Exquisite Site Built Millwork, And Decadent Finish...
RE/MAX HOUSE OF REAL ESTATEMLS® #C4285748
Disclaimer: Information herein deemed reliable but not guaranteed by CREB®.
Listing information last updated on July 13th, 2020 at 7:45am MDT.