242 June Rd, Stamford, CT 06903
Property image
Property image
OFF MARKET

$1,139,140

Tax assessed value

    242 June Rd, Stamford, CT 06903

    North Stamford

    Home Value

    Learn more about this home's value by checking out the value of nearby homes and how much similar homes have sold for.

    Comparable sales

    These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
    Address
    Distance
    Property Type
    Sold Price
    Sold Date
    Bed
    Bath
    Sqft
    1.52
    Lot/Land
    $640,000
    10/10/25
    -
    -
    1.91
    Lot/Land
    $3,300,000
    02/05/26
    -
    -
    2.73
    Lot/Land
    $700,000
    11/07/25
    7
    -
    7,685
    2.56
    Lot/Land
    $4,700,000
    12/19/25
    5
    3
    3,622
    2.65
    Lot/Land
    $1,375,000
    08/03/26
    3
    1
    1,482
    3.12
    Lot/Land
    $3,625,000
    11/20/25
    -
    -
    3.13
    Lot/Land
    $5,600,000
    07/08/26
    4
    4
    6,669
    3.09
    Lot/Land
    $1,500,000
    06/22/26
    3
    2
    1,956
    3.47
    Lot/Land
    $975,000
    01/05/26
    -
    -
    3.75
    Lot/Land
    $6,687,500
    03/13/26
    -
    -

    Nearby home prices

    Get a sense of expected prices in the area by checking the value of nearby homes.
    Address
    Distance
    Price
    Bed
    Bath
    Sqft
    Status
    0.13
    -
    4
    3.5
    4,085
    Off Market
    0.15
    -
    -
    -
    -
    Off Market
    0.13
    -
    4
    4.5
    4,193
    Off Market
    0.14
    -
    5
    7
    8,883
    Off Market
    0.28
    $1,531,000
    3
    3
    2,981
    Off Market
    0.28
    $1,517,600
    3
    3
    2,981
    Off Market
    0.30
    $3,093,300
    4
    4.5
    3,433
    Off Market
    0.26
    $1,759,100
    3
    4
    3,228
    Off Market
    0.33
    $8,250,000
    6
    7.5
    9,440
    For Sale
    0.31
    $2,000,000
    5
    4.5
    3,833
    Recently Sold
    0.37
    $3,761,100
    3
    5
    5,299
    Off Market
    0.43
    $824,900
    3
    2
    2,000
    Off Market

    Homes for rent near 242 June Rd

    Skip to last item
    Skip to first item

    Local Information

    • Map ViewExplore the area around 242 June Rd.
    • Schools1 Elementary School1 Middle School1 High School
    • Shop & Eat
    -- mins to
    Commute Destination

    Home Highlights

    Lot/Land
    39 acre lot

    About this House

    OWN THE EXTRAORDINARY A rare estate of 39 acres beyond all expectations. The House: This 13 year young custom designed home has stunning curb appeal w/its elegant approach & Greenwich address. The residence has open airy living spaces w/incredible detailed millwork, stonewalled fireplaces and high ceilings, a deluxe cook's kitchen opening to an impressive family room & gracious dining room. The master suite, replete w/an office/lounging room, fireplace, two huge closets, luxury bath & double balconies for stunning views. Also included are 4 add'l en suite sleeping quarters. French doors everywhere, and an exquisite wraparound porch that overlooks the exquisite grounds. Add it to this a LL walkout entertainment area. Another enhancement is the handsome gunite IG pool. The Land: 39 acres of rare picturesque fantasy. A little touch of Ireland in Southwest Connecticut. The property has spectacular views of an expanse of lush meadowlands, gentle hills & dales, two ponds & 17th century stonewalls. This type of truly breathtaking beauty is seldom found. It also is a precious horse property w/a world-class barn of 9 stalls, paddocks & 150 miles of riding trails directly across the road. Estate Extras: A second home...Frank Lloyd Wright-inspired glass contemporary with its own IG pool and views beyond compare. Added to all of this is a tennis ct and an orchard of fruit trees. Country Quiet-City Close. The new Greenwich Country Day High School just down Stanwich Road opens Sept. 2019.
    242 June Rd, Stamford, CT 06903 is a lot/land in North Stamford. This property is not currently displayed as for sale or rent on Trulia.

    Home Details for 242 June Rd

    Exterior Features

    Exterior Home Features
    Roof: OtherExterior: OtherPatio
    Pool
    Pool

    Property Information

    Property Type / Style
    Property Type: Lot Land

    Interior Features

    Heating & Cooling
    Air Conditioning
    Levels, Entrance, & Accessibility
    Floors: Other

    Community

    Units in Building: 1

    Lot Information

    Lot Area: 39.00 acres

    Building

    Fitness & Sports
    Tennis Court

    Price and Tax history

    DateEventPrice
    Dec 6, 2019
    Source: Agent Provided
    ListingRemoved
    $9,750,000
    Jun 14, 2019
    Source: Agent Provided
    Listed For Sale
    $9,750,000
    Dec 3, 2018
    Source: Agent Provided
    ListingRemoved
    $9,950,000
    Apr 6, 2018
    Source: Agent Provided
    Listed For Sale
    $9,950,000

    Market trends in Stamford

    Last updated August 2026
    Buyer'sMarketSeller'sMarket
    Avg. sale price
    $719K
    $40K
    MoM
    Sale-to-List Price
    102.6%
    0.1%
    MoM
    Price per sq ft
    $406
    $3
    MoM
    Available listings
    271
    18
    MoM

    Around this home

    Neighborhood Overview

    Neighborhood stats provided by third party data sources.

    What Locals Say about North Stamford

    At least 92 Trulia users voted on each feature.
    • 94 % Say it's quiet

    • 91 % Say car is needed

    • 90 % Say yards are well-kept

    • 90 % Say it's dog friendly

    • 87 % Say there's wildlife

    • 86 % Say parking is easy

    • 76 % Say there's holiday spirit

    • 72 % Say they plan to stay for at least 5 years

    • 65 % Say neighbors are friendly

    • 64 % Say people would walk alone at night

    • 50 % Say kids play outside

    • 44 % Say there are community events

    • 13 % Say it's walkable to grocery stores

    • 12 % Say it's walkable to restaurants

    • 11 % Say there are sidewalks

    • 11 % Say streets are well-lit

    Sourced by Trulia users. Learn more about our methodology.
    • dawnashleyo
      "Quiet and more space! I miss having coffee down the street, but my wonderful neighbors make up for it. Get used to deer and chipmunks. There are no sidewalks but quiet streets "
    • Trulia User
      "Lots of country to explore with an owner, in parks etc. but not off leash. Lots of wildlife so dogs cannot be left outside at night. "
    • Erin M.
      "Right off Merritt and 10 minutes from train. Ultimate location in the quiet woodsy part of Stamford!"
    • Erin M.
      "Very quiet, lots of space and trees, perfect for raising kids near the city. I love being in a secluded area but just 10 minutes from downtown stamford. "
    • Austin C
      "Chestnut Hill Park is one of the best playgrounds around. It is at the foot of Chestnut Hill Lane (one of the best streets in North Stamford). "
    • Gladysrezabek
      "Friendly neighbors and a sense of community. Safe environment to raise kids and easy commute into NYC"
    • Trulia User
      "There are many streets for walks! It is very safe; however, lighting can be a bit sparse. It’s well worth the additional commute time to have more space."
    • Dan
      "Many, many homes have dogs. We walk ours in the neighborhood everyday and interact with 2 to 5 neighbors walking their dogs on a daily basis. "
    • Amexspec
      "I love my neighborhood. It’s quiet and kids safe. Neighbors are respectful. Schools are great and so is the community. Major highways are close to us too."
    • Sazmar
      "Large yards quite peaceful wildlife no pollution. "
    • Lauren s.
      "The perfect mix of country but 10-15 min from a city (downtown Stamford). Trains to NYC are 50 min and run every few minutes. Down to earth people from all different backgrounds and variety of income. Great place to expose your family to diversity..."
    • satjack
      "I've lived in this neighborhood for 20 years. The neighbors are friendly. Great place to go for walks Very convenient to NYC and CT shore. Wonderful place to have a family. The natural beauty year round is simply beautiful."
    • gerrypholmes
      "Great family community, Ideal for raising a family. Space and privacy. "
    • GG
      "Close to all that NYC has to offer and all that Connecticut has to offer...Perfect for families, great shopping and dining!"
    • Garyfalitsa
      "This area is great for families or for couples who want to start a family. Great location in nature for raising kids exploring and walking outdoors. magnet schools close by as we'll as many good private schools. Very quiet and safe neighborhood environment, with an upcoming park near scofieldtown rd. City water a plus!"

    LGBTQ Local Legal Protections

    Frequently asked questions about 242 June Rd

    • Is Stamford a buyer's or seller's market?
      Stamford is currently a seller's market, based on recent for-sale activity.
    • What's the median sale price in Stamford?
      The median sale price in Stamford is $719K. That is up $40K from the prior month.
    • What do residents say about the North Stamford neighborhood?
      Residents describe the North Stamford neighborhood in Stamford, CT as quiet, well-kept, and dog-friendly. Most residents say you need a car. See recently sold homes in North Stamford, Stamford.
    • What are the closest schools to 242 June Rd?
      The closest schools to 242 June Rd in Stamford, CT are Cloonan School (Middle, rated 4/10), Roxbury School (Elementary, rated 4/10), Westhill High School (rated 3/10).

    Explore by feature - Pet Friendly

    Explore by feature - Garage

    Explore by feature - Air Conditioning

    Explore by feature - Pool

    Explore by feature - Washer/dryer

    Explore by feature - Outdoor Space

    Apartments for Rent

    Skip to last item
    Skip to first item

    Off Market Homes Near 242 June Rd

    Skip to last item
    Skip to first item

    Homes for sale near 242 June Rd

    Skip to last item
    Skip to first item
    Skip to last item
    • Results are loading
    Skip to first item