Calgary New Listings Last 24 Hours | Updated Real Estate Calgary New Listings Last 24 Hours

Stay ahead in Calgary’s dynamic real estate market with Calgary new listings last 24 hours. These fresh properties offer you the chance to be among the first to view the latest homes for sale, from single-family homes to condos and townhouses.

Discover Calgary new listings last 24 hours for single-family homes and condos, perfect for families, professionals, and investors. These properties are located in desirable neighborhoods and feature modern designs, updated kitchens, and open-concept layouts.

Looking for affordability? Check out affordable Calgary homes for sale listed in the past 24 hours under $500,000. These homes provide excellent value and are situated in family-friendly communities with access to schools, parks, and public transit.

If luxury living is what you seek, explore luxury homes in Calgary listed in the last 24 hours in top neighborhoods like Aspen Woods and Beltline. These properties offer high-end finishes, spacious layouts, and premium locations.

Don’t miss your chance to find the perfect property. Start your search today and be the first to discover Calgary’s newest listings!

Contact Diane Richardson

Phone: 403.397.3706

Email: diane@mypadcalgary.com

Here are a few ways to make it easy for you to get in touch with Diane Richardson:

  1. Contact form: A contact form on my website can allow you to send me a message directly from this page. Be sure to include your name, email address, and a message.

  2. Phone number: Included is my phone number here on the page can allow you to call you me directly with any questions or to schedule viewings. 403.397.3706

  3.  Email address: an email address ( Diane@Mypadcalgary.com )can allow you to reach out to me with any questions or to request more information.

  4. Live chat: I have a live chat feature on this website, you can get in touch with me in real-time and get immediate answers to your questions.

    Please be sure to include the property address or MLS® number for the listing you are interested in.

Forgot password Extend Verify Contact

290064 240 Street W
NONE Rural Foothills County T0L 1K0

$2,145,000
Residential beds: 4 baths: 3.0 1,963 sq. ft. built: 1998

Main Photo: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 1: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 2: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 3: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 4: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 5: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 6: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 7: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 8: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 9: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 10: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 11: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 12: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 13: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 14: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 15: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 16: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 17: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 18: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 19: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 20: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 21: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 22: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 23: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 24: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 25: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 26: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 27: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 28: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 29: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 30: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 31: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 32: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 33: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 34: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 35: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 36: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 37: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 38: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 39: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 40: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 41: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 42: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 43: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 44: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 45: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 46: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Photo 47: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2217557
Bedrooms:
4
Bathrooms:
3
Year Built:
1998
This VERY special property is hitting the market for the first time!! If you are looking for a large property with a sprawling walkout bungalow, an abundance of trees and privacy, and EVERY window facing the Majestic Rocky Mountains... then you have found it ! 2 parcels offered for sale together. The house plus 11.32 acres features a meandering driveway into the property. Perfectly perched on a hill for the views that will take your breath away. The almost 2000 sq ft bungalow offers a huge entranceway. Natural light from the windows and skylights will guide you through the perfect floorplan. 3 fireplaces on the main level (2 gas one wood burning) will keep you warm and cozy through the winter months. with all the living spaces being so large, you will love to entertain family and friends in this home. The main level boasts a 4 season sunroom , a galley style kitchen , a huge dining space , a living room, huge primary bedroom with walk in closet and 5 piece ensuite, a well appointed laundry room with sink, a second bedroom , 4 piece bathroom, and an entrance that will charm you right from the moment you walk in. The walkout lower level features 2 more bedrooms ( plus flex room) a large rec area - complete with hot tub- and another bathroom. Imagine the joy of living here with your kids and animals ,with so much space to explore .The front parcel with home has a small pond where you can watch the ducks visit and hear the frogs and crickets singing. Graze your horses in the front fenced pasture. The second parcel with over 58 acres provides a forest full of adventures. A pond at the back for skating in the winter, a small hike to an opening with magical views. Lasting memories and special moments will be made on this property. There truly is alot to fall in love with at this special property. Call your favorite realtor today to book your private tour
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Suite:
Suite - Illegal
Home Style:
Acreage with Residence, Bungalow
Total Living Area:
1,963 sq. ft.
Main Level Finished Area:
1,963 sq. ft.
Below Grade Finished Area:
1,661 sq. ft.
Lot Area:
69.8 acre(s)
Front Exposure:
East
Levels:
One
Total Rooms Above Grade:
6
Year built:
1998 (Age: 27)
Bedrooms:
4 (Above Grd: 2)
Bedrooms Above Grade:
2
Bedrooms Below Grade:
2
Bathrooms:
3.0 (Full:3, Half:0)
Plan:
9612210
Heating:
In Floor, Forced Air
Basement:
Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Brick, Composite Siding, Wood Frame
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Ceramic Tile, Hardwood
Cooling:
None
Fireplaces:
3
Fireplace Details:
Gas, Wood Burning
Water Supply:
Cistern, Well
Sewer:
Septic System
Garage:
1
Garage Spaces:
6
Parking:
Triple Garage Detached
Laundry Features:
Main Level
NONE
Dishwasher, Dryer, Garage Control(s), Gas Stove, Refrigerator, Washer
hot tub
Utility Right Of Way
Floor
Type
Size
Other
Main Floor
Bedroom
12'3" × 11'1"
Main Floor
Dining Room
21'5" × 12'2"
Main Floor
Entrance
14'10" × 12'4"
Main Floor
Kitchen
15'5" × 10'
Main Floor
Laundry
7'8" × 5'1"
Main Floor
Living Room
17'3" × 14'8"
Main Floor
Bedroom - Primary
21'7" × 15'2"
Main Floor
Sunroom/Solarium
16' × 11'6"
Lower Level
Flex Space
9'2" × 9'1"
Lower Level
Bedroom
14'10" × 12'4"
Lower Level
Bedroom
12'11" × 9'11"
Lower Level
Game Room
32'5" × 29'1"
Floor
Ensuite
Pieces
Other
Main Floor
No
4
Main Floor
Yes
5
Lower Level
No
3
Title to Land:
Fee Simple
Community Features:
None
Interior Features:
Ceiling Fan(s), Central Vacuum, Closet Organizers, High Ceilings, No Smoking Home, Skylight(s), Vaulted Ceiling(s)
Exterior Features:
Private Yard
Patio And Porch Features:
Balcony(s), Deck, Wrap Around
Lot Features:
Landscaped, Native Plants, Pasture, Rolling Slope, Treed, Views, Wooded
Num. of Parcels:
0
Fencing:
Cross Fenced
Nearest Town:
Millarville
Region:
Foothills County
Zoning:
CR
Listed Date:
May 04, 2025
  • Photo 1: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 1 of 47
  • Photo 2: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 2 of 47
  • Photo 3: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 3 of 47
  • Photo 4: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 4 of 47
  • Photo 5: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 5 of 47
  • Photo 6: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 6 of 47
  • Photo 7: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 7 of 47
  • Photo 8: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 8 of 47
  • Photo 9: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 9 of 47
  • Photo 10: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 10 of 47
  • Photo 11: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 11 of 47
  • Photo 12: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 12 of 47
  • Photo 13: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 13 of 47
  • Photo 14: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 14 of 47
  • Photo 15: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 15 of 47
  • Photo 16: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 16 of 47
  • Photo 17: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 17 of 47
  • Photo 18: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 18 of 47
  • Photo 19: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 19 of 47
  • Photo 20: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 20 of 47
  • Photo 21: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 21 of 47
  • Photo 22: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 22 of 47
  • Photo 23: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 23 of 47
  • Photo 24: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 24 of 47
  • Photo 25: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 25 of 47
  • Photo 26: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 26 of 47
  • Photo 27: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 27 of 47
  • Photo 28: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 28 of 47
  • Photo 29: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 29 of 47
  • Photo 30: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 30 of 47
  • Photo 31: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 31 of 47
  • Photo 32: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 32 of 47
  • Photo 33: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 33 of 47
  • Photo 34: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 34 of 47
  • Photo 35: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 35 of 47
  • Photo 36: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 36 of 47
  • Photo 37: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 37 of 47
  • Photo 38: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 38 of 47
  • Photo 39: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 39 of 47
  • Photo 40: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 40 of 47
  • Photo 41: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 41 of 47
  • Photo 42: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 42 of 47
  • Photo 43: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 43 of 47
  • Photo 44: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    lot 4 - 58.49 acres
  • Photo 45: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Lot 1 - 11.32 acres
  • Photo 46: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 46 of 47
  • Photo 47: 290064 240 Street W: Rural Foothills County Detached for sale : MLS®# A2217557
    Photo 47 of 47

Virtual Tour

Virtual Tour

Listed by RE/MAX iRealty Innovations
Data was last updated May 15, 2025 at 12:05 PM (UTC)
Area Statistics
Listings on market:
80
Avg list price:
$2,120,000
Min list price:
$179,900
Max list price:
$14,900,000
Avg days on market:
31
Min days on market:
1
Max days on market:
709
Avg price per sq.ft.:
$752.37
These statistics are generated based on the current listing's property type and located in Rural Foothills County. Average values are derived using median calculations.
DIANE RICHARDSON
Contact Info:
403-397-3706

Contact Diane Richardson

Data is supplied by Pillar 9™ MLS® System. Pillar 9™ is the owner of the copyright in its MLS®System. Data is deemed reliable but is not guaranteed accurate by Pillar 9™.
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.