For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Hampden 01095
5 Squire Drive
$810,000
● House - Off Market

5 Squire Drive

Wilbraham, MA 01095
bedrooms
4 Beds
bathrooms
4 Baths, 1 Half Bath
square feet
3,842 Ft²
$824,283
RealtyHop Estimate
3.05%
Since Apr 1, 2023
National-US
Primary Model

About This Property

MAGNIFICENT SPRAWLING RANCH IN WILBRAHAM. This new construction home is one of a kind and is 90 percent done! There are 5 bedrooms, four and a half bathrooms and fully finished walk out basement. OPEN FLOOR plan on with beautiful kitchen island and ceiling to floor cabinets. Fireplace in the living room which leads to the office and French doors to the outdoor covered patio! Master suite with elegant bathroom with soaking tub and walk in closet. Second master suite is on the other side of the. House along with a jack and Jill bathroom within the two other bedrooms. Fully finished basement with laundry room and full bathroom. Two huge rooms can be whatever you want it to be! This is a dream home with a three car garage! DONT MISS OUT!
Unit Size
3,842 Ft²
Days on Market
-
Land Size
0.75 acres
Price per sqft
$208
Property Type
House
Property Taxes
-
HOA Dues
-
Year Built
2022

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 6 months ago (MLSPIN #73063138)

Price History

Date / Event Date Event Price
Mar 1, 2023 Sold
Premium
Sold
Jan 12, 2023 In contract -
In contract
Dec 6, 2022 Listed by Executive Real Estate, Inc. $799,900
Listed by Executive Real Estate, Inc.

Property Highlights

Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 2022
  • Effective Year Built: 2022
  • Building Count: 1
  • Total Rooms: 7
  • Bedroom Count: 5
  • Bathroom Count: 5
  • Full Bathrooms: 4
  • Partial Bathrooms: 5
  • Building Condition: 3
  • Building Quality: 0
  • Construction Type: 0
  • Building Style: 21
  • Exterior Walls Type: 19
  • Interior Walls Type: 0
  • Roof Shape Type: 1
  • Roof Cover Type: 13
  • Floor Count: 200
  • Floor Cover: 0
  • Basement Type: 0
  • Basement Area: 0
  • Garage Type: 0
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 63,088
  • Total Building Area: 3,027
  • Gross Building Area: 7,376
  • Building Area: 3,027
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 13
  • Heating: 4
  • Heated Square Feet: 3,027
  • Heating Fuel Type: 6

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000001448
  • Standard Land Use Code: 1001
  • County Land Use Code: 101

Neighborhood

  • School District Name: Hampden-Wilbraham School District
  • School Tax School District: HMPDN-WILBRHM
  • Census Tract: 813601

Zoning

  • Zoning: R60

Geography

  • Account Number: MAP 164, 165
  • Parcel: WILB M:11080 B:5 L:101919
  • Block: 5
  • Lot: 101919
  • Municipality: WILBRAHAM
  • Latitude: 42.1415
  • Longitude: -72.3995

    Address

  • Full Address: 5 Squire Dr
  • Address - House Number: 5
  • Address - Street Name: Squire
  • Address - Suffix Type: Dr
  • State: MA
  • City Name: Wilbraham
  • Carrier Code: R004
  • 4-Digit Zip Code: 1883
  • Zip Code: 01095

Valuation

    Tax

  • Tax Year: 2024
  • Tax Amount: $1,347,500

    Appraisal Valuation

  • Standard Deviation: 0.1795
  • Valuation Date: Mar 06, 2024
  • Confidence Score: 74
  • Final Value: 491,276
  • High Value: 585,740
  • Low Value: 396,811

    Assessments Valuation

  • Assessed Year: 2024
  • Assessed Total Value: $728,400
  • Assessed Land Value: $120,300
  • Assessed Improvements Value: $608,100

    Sales

  • Current Sale Contract Date: Feb 28, 2023
  • Current Sale Recording Date: Mar 01, 2023
  • Current Sale Price:
    Premium
  • Current Sale Document Type: O
  • Current Sale Input Document Number: 9248
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Hampden

Stats & Trends

Median Asking:

$350,000

Sale Price/ft²

$229

Above Asking

0.73%

Average Days on Market

55

Average Home Size

2069 ft²

Average Home Age

80.3 years

Currently For Sale

875 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Rentals Near You

Click here to view more rentals in the neighborhood.
Last Updated: 6 months ago
Data Source: MLS PIN, MLS# 73063138

Frequently Asked Questions

When was property at 5 Squire Drive built and last sold?
The property at 5 Squire Drive was built in 2022 and last sold on Feb 28, 2023 for $810,000.
How much is this home worth?
The estimated value of the home located at 5 Squire Drive is $809,410.
What are some comparable homes to 5 Squire Drive?
There are currently no comparable homes to 5 Squire Drive.
Recent Neighborhood News
Haunted NYC Real Estate: 6 Spooky Stories Behind the Addresses
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
Popular Searches
Wilbraham Homes for Sale
Wilbraham Houses for Sale
Wilbraham Condos for Sale
Wilbraham Multifamily for Sale
Wilbraham Land for Sale
Wilbraham Commercial for Sale
Wilbraham Homes with Basements
Wilbraham Homes with Pools
Nearby Cities
Springfield Homes for Sale
Chicopee Homes for Sale
Longmeadow Homes for Sale
Palmer Town Homes for Sale
Belchertown Homes for Sale
Sherwood Manor Homes for Sale
Monson Center Homes for Sale
Hazardville Homes for Sale
Nearby Property Records
Hampden County, MA Property Records
Hampshire County, MA Property Records
Tolland County, CT Property Records
Windham County, CT Property Records
Franklin County, MA Property Records
Hartford County, CT Property Records
Worcester County, MA Property Records
Berkshire County, MA Property Records
Neighborhoods
Forest Park Real Estate
Sixteen Acres Real Estate
East Forest Park Real Estate
Liberty Heights Real Estate
Pine Point Real Estate
East Springfield Real Estate
Indian Orchard Real Estate
Boston Road Real Estate
Nearby Counties
Springfield Homes for Sale
Chicopee Homes for Sale
Longmeadow Homes for Sale
Ludlow Homes for Sale
East Longmeadow Homes for Sale
South Hadley Homes for Sale
Palmer Town Homes for Sale
Enfield Homes for Sale
Top Real Estate Agents
Top Agents in Wilbraham
Top Agents in Springfield
Top Agents in Springfield
Top Agents in Chicopee
Top Agents in Chicopee
Top Agents in 01108
Top Agents in Forest Park
Top Agents in Sixteen Acres