OFF MARKET
507 Neighborhood Rd
New Haven, MO 63068
4 Beds
7 Baths
6,608 sqft (on 90.40 acres)
- 4 Beds
- 7 Baths
- 6,608 sqft (on 90.40 acres)
4 Beds
7 Baths
6,608 sqft
(on 90.40 acres)
Homes for Sale Near 507 Neighborhood Rd
Skip to last item
Skip to first item
Local Information
© Google
-- mins to
Commute Destination
Description
This property is no longer available to rent or to buy. This description is from March 31, 2022
Plenty of room to roam inside & out at RidgeView Farm. This expansive Tuscan-style equestrian estate is surrounded by 90+ rolling acres on the 2nd highest point in Frnkln Cnty. Thoughtfully designed w/ rustic details & reclaimed materials, this light-filled villa brings the outdoors in through walls of glass. The open-plan great room is a perfect spot for friends & family to connect by staying close to the kitchen, din room, & warmed by a stone fireplace. A loft overlooks the great room creating a cozy library or music room. Your private Mstr ste filled w/ luxurious amenities, fine detailing, an immense custom walk-in closet & dressing room. A flexible office/sunroom for quiet creativity features 3 walls of windows. Step outside to your expansive htd pool to spend a leisurely afternoon soaking & sunning. Conceived for horse lovers, the estate includes 2 barns & outbuildings awaiting you & your herd. Play, ride & explore your sweeping property & relax into your dream country lifestyle.
Home Highlights
Parking
3 Car Garage
Outdoor
Pool
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 507 Neighborhood Rd
Active Status |
|---|
MLS Status: Closed |
Interior Features |
|---|
Interior Details Basement: Concrete,Full,Unfinished,Walk-Out AccessNumber of Rooms: 14Types of Rooms: Dining Room, Office, Family Room, Kitchen, Living Room, Bedroom, Storage, Loft, Other Room |
Beds & Baths Number of Bedrooms: 4Main Level Bedrooms: 2Number of Bathrooms: 7Number of Bathrooms (full): 4Number of Bathrooms (half): 3Number of Bathrooms (main level): 4 |
Dimensions and Layout Living Area: 6608 Square Feet |
Appliances & Utilities Appliances: Dishwasher, Gas Cooktop, Microwave, Gas Oven, RefrigeratorDishwasherMicrowaveRefrigerator |
Heating & Cooling Heating: Forced Air,GasHas CoolingAir Conditioning: Electric,ZonedHas HeatingHeating Fuel: Forced Air |
Fireplace & Spa Number of Fireplaces: 3Fireplace: Gas, Family Room, Kitchen, Master BedroomHas a Fireplace |
Windows, Doors, Floors & Walls Window: Insulated WindowsDoor: French Doors |
Levels, Entrance, & Accessibility Levels: Two |
Exterior Features |
|---|
Exterior Home Features Fencing: PartialOther Structures: Barn(s), Equipment Shed, Grain Storage, Outbuilding, Poultry Coop, Silo(s), Stable(s), StorageExterior: DockHas a Private Pool |
Parking & Garage Number of Garage Spaces: 3Number of Covered Spaces: 3Other Parking: Driveway: GravelNo CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 3Parking: Attached,Circular Driveway,Garage Door Opener,Oversized,Rear/Side Entry |
Pool Pool |
Frontage Waterfront: Pond/LakeNot on Waterfront |
Farm & Range Allowed to Raise Horses |
Finished Area Finished Area (above surface): 6608 Square Feet |
Property Information |
|---|
Year Built Year Built: 1998 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Rustic,Other,Other |
Building Construction Materials: Brick |
Property Information Parcel Number: 1142000000001000Model Home Type: Custom |
Price & Status |
|---|
Price List Price: $4,450,000 |
Status Change & Dates Possession Timing: Close Of Escrow |
Media |
|---|
Location |
|---|
Direction & Address City: New HavenCommunity: None |
School Information Elementary School: Campbellton Elem.Jr High / Middle School: Washington MiddleHigh School: Washington HighHigh School District: Washington |
Building |
|---|
Building Details Builder Name: Understall |
Building Area Building Area: 6608 Square Feet |
Community |
|---|
Community Features: Private Inground Pool |
HOA |
|---|
Association for this Listing: St. Louis Association of REALTORS |
Lot Information |
|---|
Lot Area: 90.4 Acres |
Listing Info |
|---|
Special Conditions: Standard |
Offer |
|---|
Contingencies: Subj. to Clos-Seller |
Compensation |
|---|
Buyer Agency Commission: 2.0Buyer Agency Commission Type: %Sub Agency Commission: n/aTransaction Broker Commission: n/a |
Notes The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed |
Business |
|---|
Business Information Ownership: Private |
Miscellaneous |
|---|
BasementMls Number: 21031356 |
Additional Information |
|---|
Private Inground PoolMlg Can ViewMlg Can Use: IDX |
Last check for updates: about 18 hours ago
Listed by Donna M Calamia, (314) 368-0279
RedKey Realty Leaders
Bought with: Shayla S Kurzenberger, (314) 541-3018, Dolan, Realtors
Originating MLS: St. Louis Association of REALTORS
Source: MARIS, MLS#21031356
Price History for 507 Neighborhood Rd
| Date | Price | Event | Source |
|---|---|---|---|
| 03/23/2022 | $4,450,000 | Pending | MARIS #21031356 |
| 03/02/2022 | $4,450,000 | Contingent | MARIS #21031356 |
| 10/23/2021 | $4,450,000 | Listed For Sale | MARIS #21031170 |
Property Taxes and Assessment
| Year | 2023 |
|---|---|
| Tax | $8,791 |
| Assessment | $836,980 |
Home facts updated by county records
Comparable Sales for 507 Neighborhood Rd
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
1.43 | Single-Family Home | - | 11/21/23 | 4 | 2 | 2,067 | |
1.37 | Single-Family Home | - | 11/17/23 | 4 | 4 | 2,588 | |
1.64 | Single-Family Home | - | 07/07/23 | 4 | 3 | 2,917 | |
2.02 | Single-Family Home | - | 11/01/23 | 3 | 4 | 4,744 | |
1.95 | Single-Family Home | - | 03/28/24 | 3 | 4 | 3,771 | |
2.00 | Single-Family Home | - | 08/25/23 | 4 | 3 | 1,740 | |
2.35 | Single-Family Home | - | 06/05/23 | 3 | 4 | 3,668 | |
2.41 | Single-Family Home | - | 09/08/23 | 4 | 3 | 3,500 | |
2.62 | Single-Family Home | - | 06/21/23 | 4 | 4 | 4,605 | |
2.67 | Single-Family Home | - | 12/07/23 | 4 | 3 | 2,000 |
Assigned Schools
These are the assigned schools for 507 Neighborhood Rd.
- Campbellton Elementary School
- PK-6
- Public
- 133 Students
N/AGreatSchools RatingParent Rating AverageCampbellton Elementary is a wonderful family oriented small school where students get the individual help that they need to be successful. PBS (Positive Behavior Supports) was just implemented during the 2014-15 school year. Prior to this year PBS was implemented in other School District of Washington Schools, but not at Campbellton.Teacher Review9y ago - Washington Middle School
- 7-8
- Public
- 606 Students
5/10GreatSchools RatingParent Rating AverageLike WHS this school has a strong bias between local townie kids and outsiders, be it those who moved in or country kids. This bias leads to relentless bullying that was present in my generation and my daughter’s one. Kids are either powerful and popular townsfolk kids (and become the jocks or cheerleaders) or they are treated like the nerds in popular 1980’s movies by the same name. The townie kids “can do no wrong” and never get in trouble no matter how much physical damage they do to a kid they are abusing, but that kid hits back and they are immediately suspended. The administration, teachers, and staff are are locals and do things the way it always was done. Drugs are not as big of an issue at this school as the high school but they are definitely present and used on campus. Likewise sexual harassment is less so than the high school (which has serious problems) but still is present and entirely tolerated by staff so long as it doesn’t happen to popular girls.Parent Review2y ago - Washington High School
- 9-12
- Public
- 1347 Students
5/10GreatSchools RatingParent Rating AverageAn excellent education for every student through to graduation.Parent Review11mo ago 
Check out schools near 507 Neighborhood Rd.
Check with the applicable school district prior to making a decision based on these schools. Learn more.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed. Some IDX listings have been excluded from this website. Click here for more information
The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.
The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.
Homes for Rent Near 507 Neighborhood Rd
Skip to last item
Skip to first item
Off Market Homes Near 507 Neighborhood Rd
Skip to last item
Skip to first item
507 Neighborhood Rd, New Haven, MO 63068 is a 4 bedroom, 7 bathroom, 6,608 sqft single-family home built in 1998. This property is not currently available for sale. 507 Neighborhood Rd was last sold on Mar 29, 2022 for $0. The current Trulia Estimate for 507 Neighborhood Rd is $2,947,700.