NOT LISTED FOR SALE

42624 Freistadt Square Sterling, VA 20166

Estimated Value: $617,000 - $627,000

3 Beds
4 Baths
2,240 Sq Ft
$278/Sq Ft Est. Value

Highlights

  • Gourmet Kitchen
  • View of Trees or Woods
  • Colonial Architecture
  • Rock Ridge High School Rated A+
  • Open Floorplan
  • 2-minute walk to Arcola Center Community Park and Pool

About This Home

As of June 2017

Better than new! Spacious 3 BR + Office TH with open floor plan and 9" ceilings. Gourmet Kit. w/mocha cabs, SS appl. (inc. gas range) granite counters, recessed. lights & "sea surf" back splash. King size, sunny MBR w/large walk-in closet, ceiling fan, plus MBA w/2 sinks in tall vanity & decorator tile in shower. Samsung front load W/D. Lg deck w/furniture. Fin. garage. Ample parking by tot lot.

Last Agent to Rent the Property

Gerry Staudte

Long & Foster Real Estate, Inc. Listed on: 04/27/2017

Long & Foster Real Estate, Inc.

Co-Listed By

Barbara Nowak

Long & Foster Real Estate, Inc.

Last Renter's Agent

Noemy Martinez Conaway

Samson Properties

Samson Properties

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $4,790

Year Built

  • Built in 2014

Lot Details

  • 1,742 Sq Ft Lot
  • Two or More Common Walls
  • Property is in very good condition

Parking

  • 2 Car Attached Garage
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Asphalt Roof

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Family Room
  • Combination Dining and Living Room
  • Game Room
  • Views of Woods

Kitchen

  • Gourmet Kitchen
  • Breakfast Area or Nook
  • Gas Oven or Range
  • Microwave
  • Ice Maker
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • 4 Bathrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Front and Rear Basement Entry
  • Basement Windows

Schools

  • Creightons Corner Elementary School
  • Stone Hill Middle School
  • John Champe High School

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Underground Utilities
  • Natural Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Residential Lease
  • Security Deposit $2,250
  • Tenant pays for lawn/tree/shrub care, light bulbs/filters/fuses/alarm care, exterior maintenance, minor interior maintenance, all utilities
  • Rent includes hoa/condo fee, trash removal
  • No Smoking Allowed
  • 24-Month Lease Term
  • Available 6/15/17
  • $45 Application Fee
  • Assessor Parcel Number 163370197000

Community Details

Overview

  • Property has a Home Owners Association
  • Association fees include management, insurance, snow removal, trash
  • Built by RYAN
  • Arcola Subdivision, Mozart Floorplan
  • The community has rules related to alterations or architectural changes

Amenities

  • Common Area
  • Community Center
  • Party Room

Recreation

  • Community Playground
  • Community Pool

Pet Policy

  • No Pets Allowed

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$4,790

Year Built

Built in 2014

Lot Details

0

Parking

2

Rental Info

  • Date Available: 2017-06-15
  • Application Fee: 45.00
  • Lease Term: 24 Months
  • Pets Allowed: No
  • Rent Includes: Hoa/Condo Fee, Trash Removal
  • Security Deposit: 2250.00
  • Smoking Allowed Yn: No
  • Tenant Pays: Lawn/Tree/Shrub Care, Light Bulbs/Filters/Fuses/Alarm Care, Exterior Maintenance, Minor Interior Maintenance, Utilities - All
  • Vacation Rental: No
  • Max Lease in Months: 24
  • Min Lease in Months: 24

Listing Details

  • Property Type: Residential Lease
  • Structure Type: Interior Row/Townhouse
  • Architectural Style: Colonial
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Year Built: 2014
  • Remarks Public: Better than new! Spacious 3 BR + Office TH with open floor plan and 9" ceilings. Gourmet Kit. w/mocha cabs, SS appl. (inc. gas range) granite counters, recessed. lights & "sea surf" back splash. King size, sunny MBR w/large walk-in closet, ceiling fan, plus MBA w/2 sinks in tall vanity & decorator tile in shower. Samsung front load W/D. Lg deck w/furniture. Fin. garage. Ample parking by tot lot.
  • Special Features: None
  • Property Sub Type: Townhouses

Interior Features

  • Appliances: Disposal, Dryer, Dishwasher, Exhaust Fan, Icemaker, Microwave, Oven/Range - Gas, Refrigerator, Washer
  • Interior Amenities: Breakfast Area, Kitchen - Gourmet, Combination Dining/Living, Primary Bath(s), Floor Plan - Open
  • Fireplace: No
  • Common Walls: 2+ Common Walls
  • Wall Ceiling Types: 9'+ Ceilings
  • Entry Location: Foyer
  • Levels Count: 3+
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Game Room, Family Room
  • Basement: Yes
  • Basement Type: Front Entrance, Outside Entrance, Rear Entrance, Full, Walkout Level, Heated, Fully Finished, Windows
  • Living Area Units: Square Feet
  • Total Sq Ft: 2240
  • Living Area Sq Ft: 2240
  • Price Per Sq Ft: 1.28
  • Above Grade Finished Sq Ft: 1760
  • Below Grade Finished Sq Ft: 480
  • Total Below Grade Sq Ft: 480
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 42624

Beds/Baths

  • Bedrooms: 3
  • Total Bathrooms: 4
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Upper Level Full Bathrooms: 2
  • Main Level Half Bathrooms: 1
  • Lower Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Combination, Brick
  • Pool Private: No
  • Roof: Asphalt
  • View: Trees/Woods
  • View: Yes
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Garage
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Off Street, Attached Garage

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Cooling: Yes
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv Available, Under Ground
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Common Grounds, Community Center, Party Room, Pool - Outdoor, Swimming Pool, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Management, Insurance, Snow Removal, Trash
  • HOA Condo Co-Op Rules: Alterations/Architectural Changes
  • HOA: Yes
  • Senior Community: No

Schools

  • School District: LOUDOUN COUNTY PUBLIC SCHOOLS
  • Elementary School: CREIGHTONS CORNER
  • Middle School: STONE HILL
  • High School: JOHN CHAMPE
  • School District Key: 121139189813
  • Elementary School: CREIGHTONS CORNER
  • High School: JOHN CHAMPE
  • Middle Or Junior School: STONE HILL

Lot Info

  • Lot Size Acres: 0.04
  • Lot Size Area: 1742
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 1742.00
  • Property Attached Yn: Yes
  • Property Condition: Very Good

Building Info

  • Builder Name: RYAN

Tax Info

  • Assessor Parcel Number: 16634990
  • Assessor Parcel Number: 163370197000
  • Tax Total Finished Sq Ft: 1760
  • Close Date: 06/28/2017

MLS Schools

  • School District Name: LOUDOUN COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 1, 2020
Sold by
Singh Amish K
Bought by
Singh Amish K and Singh Mani Prabha
Current Estimated Value
$622,575

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$342,500
Outstanding Balance
$304,383
Interest Rate
3.1%
Mortgage Type
New Conventional
Estimated Equity
$318,192

Purchase Details

Closed on
Apr 30, 2014
Sold by
Nvr Inc
Bought by
Singh Amish K

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$364,270
Interest Rate
4.32%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Singh Amish K -- None Available
Singh Amish K $383,443 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Singh Amish K $342,500
Closed Singh Amish K $364,270
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/28/2017 06/28/17 Rented $2,200 -4.3% --
06/28/2017 06/28/17 Under Contract -- -- --
04/27/2017 04/27/17 For Rent $2,300 -- --
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $4,790 $594,990 $235,000 $359,990
2024 $4,893 $565,720 $195,000 $370,720
2023 $4,843 $553,530 $195,000 $358,530
2022 $4,632 $520,450 $180,000 $340,450
2021 $4,601 $469,530 $160,000 $309,530
2020 $4,277 $413,210 $140,000 $273,210
2019 $4,242 $405,930 $140,000 $265,930
2018 $4,149 $382,440 $140,000 $242,440
2017 $4,293 $381,630 $140,000 $241,630
2016 $4,428 $386,720 $0 $0
2015 $4,269 $236,130 $0 $236,130
2014 $1,617 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: 1000729725

Bright MLS

APN: 163-37-0197