For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Longmeadow 01106
247 Crestview Cir
$387,000
● House - Off Market

247 Crestview Cir

Longmeadow, MA 01106
bedrooms
3 Beds
bathrooms
2 Baths
square feet
2,169 Ft²
$547,478
RealtyHop Estimate
35.18%
Since Oct 1, 2020
National-US
Primary Model

About This Property

Fantastic 6 Room, 3 Bedroom, 2 Bath, 2 Car Garage Ranch on a a great street off the Longmeadow Green.  This home is move in ready and sure to please.  The Large Living Room features a beautiful fireplace and a wonderful bay window with custom blinds that brightens the home.  The Living Room opens directly to the formal dining area.  The updated kitchen is sure to please any cook with granite counters and stainless steel appliances.  The large Master Bedroom Suite has lots of windows for natural lighting and a walk in closet and tiled master bathroom with granite counters.
Unit Size
2,169 Ft²
Days on Market
-
Land Size
0.51 acres
Price per sqft
$187
Property Type
House
Property Taxes
$784
HOA Dues
-
Year Built
1950

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: 4 months ago (MLSPIN #72705654)

Price History

Date / Event Date Event Price
Sep 28, 2020 Sold
Premium
Sold
Aug 6, 2020 Listed by Sears Real Estate, Inc. $405,000
Listed by Sears Real Estate, Inc.
May 3, 2019 Sold
Premium
Sold
Feb 1, 2019 Listed by Sears Real Estate, Inc. $379,000
Listed by Sears Real Estate, Inc.
Nov 30, 2017 Sold
Premium
Sold
Show More

Property Highlights

Garage
Parking Available
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1950
  • Effective Year Built: 1950
  • Building Count: 1
  • Total Rooms: 6
  • Bedroom Count: 3
  • Bathroom Count: 3
  • Full Bathrooms: 2
  • Partial Bathrooms: 3
  • Building Condition: 3
  • Building Quality: 0
  • Construction Type: 0
  • Building Style: 11
  • Exterior Walls Type: 18
  • Interior Walls Type: 0
  • Roof Shape Type: 1
  • Roof Cover Type: 15
  • Floor Count: 100
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 7
  • Basement Area: 2,153
  • Garage Type: 7
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 22,165
  • Total Building Area: 2,169
  • Gross Building Area: 5,134
  • Building Area: 2,169
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 13
  • Heating: 10
  • Heated Square Feet: 2,169
  • Heating Fuel Type: 6

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

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

Neighborhood

  • School District Name: Longmeadow School District
  • School Tax School District: LONGMEADOW SD
  • Census Tract: 813301

Zoning

  • Zoning: RA1

Geography

  • Parcel: LONG M:0195 B:0081 L:0023
  • Block: 81
  • Lot: 23
  • Municipality: LONGMEADOW
  • Latitude: 42.0444
  • Longitude: -72.5788

    Address

  • Full Address: 247 Crestview Cir
  • Address - House Number: 247
  • Address - Street Name: Crestview
  • Address - Suffix Type: Cir
  • State: MA
  • City Name: Longmeadow
  • Carrier Code: C012
  • 4-Digit Zip Code: 2327
  • Zip Code: 01106

Valuation

    Tax

  • Tax Year: 2024
  • Tax Amount: $1,069,200

    Appraisal Valuation

  • Standard Deviation: 0.1708
  • Valuation Date: Feb 07, 2024
  • Confidence Score: 78
  • Final Value: 523,354
  • High Value: 612,788
  • Low Value: 433,920

    Assessments Valuation

  • Assessed Year: 2024
  • Assessed Total Value: $517,000
  • Assessed Land Value: $174,200
  • Assessed Improvements Value: $342,800

    Sales

  • Current Sale Contract Date: Sep 18, 2020
  • Current Sale Recording Date: Sep 28, 2020
  • Current Sale Price:
    Premium
  • Current Sale Document Type: O
  • Current Sale Input Document Number: 55192
  • Previous Sale Recording Date: May 03, 2019
  • Previous Sale Contract Date: Apr 29, 2019
  • Previous Sale Amount: $360,000
  • Previous Sale Document Type: O
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 Longmeadow

Stats & Trends

Median Asking:

$519,900

Sale Price/ft²

$256

Below Asking

0.01%

Average Days on Market

50

Average Home Size

2982 ft²

Average Home Age

69.2 years

Currently For Sale

28 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: 4 months ago
Data Source: MLS PIN, MLS# 72705654

Frequently Asked Questions

When was property at 247 Crestview Circle built and last sold?
The property at 247 Crestview Circle was built in 1950 and last sold on Sep 18, 2020 for $387,000.
How much is this home worth?
The estimated value of the home located at 247 Crestview Circle is $415,014.
What are some comparable homes to 247 Crestview Circle?
There are currently no comparable homes to 247 Crestview Circle.
Recent Neighborhood News
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
The Current Status of iBuying in 2026: What To Know
Popular Searches
Longmeadow Homes for Sale
Longmeadow Houses for Sale
Longmeadow Condos for Sale
Longmeadow Townhouses for Sale
Longmeadow Multifamily for Sale
Longmeadow Land for Sale
Longmeadow Homes with Basements
Longmeadow Homes with Pools
Nearby Cities
Springfield Homes for Sale
Agawam Town Homes for Sale
Thompsonville Homes for Sale
Sherwood Manor Homes for Sale
Hazardville Homes for Sale
Suffield Depot Homes for Sale
Nearby Property Records
Hampden County, MA Property Records
Tolland County, CT Property Records
Hampshire County, MA Property Records
Hartford County, CT Property Records
Windham County, CT Property Records
Franklin County, MA Property Records
Berkshire County, MA Property Records
Middlesex County, CT Property Records
Neighborhoods
Forest Park Real Estate
Sixteen Acres Real Estate
East Forest Park Real Estate
Upper Hill Real Estate
Old Hill Real Estate
McKnight Real Estate
Six Corners Real Estate
Metro Center Real Estate
Nearby Counties
Springfield Homes for Sale
Agawam Town Homes for Sale
East Longmeadow Homes for Sale
Enfield Homes for Sale
Suffield Homes for Sale
Top Real Estate Agents
Top Agents in Longmeadow
Top Agents in Springfield
Top Agents in Springfield
Top Agents in Agawam Town
Top Agents in Agawam Town
Top Agents in 01108
Top Agents in Forest Park
Top Agents in 01089