Overview
Monthly cost
Get pre-approved
Fees & commissions
Related
Intelligence reports
Save
$665,000
$0/mo
Get pre-approvedResidential
2,782 Sq. Ft.
7,964 Sq. Ft. lot
4 Bedrooms
3 Bathrooms
282 Days on market
993775 MLS ID
Click to interact
Click the map to interact
Property details
Building
Upper Sq Ft: 1232
Above Grade Finished Area: 2782
Below Grade Finished Area: 1550
Building Area Total: 2782
Construction Materials: "Wood/Frame", "Stone"
Has Improvements: No
Main Floor Sq Ft: 1550
Total Sq Ft: 4332
Levels: "Two"
Living Area: 2782
Living Area Source: Assessor
Living Area Units: Square Feet
Stories: 2
Year Built: 2015
Appliances & Equipment
Appliances: "Electric Range/Oven", "Dishwasher", "Refrigerator", "Microwave", "Disposal"
Home Owner's Association
Association Fee: 200
Association Fee Frequency: Annually
Association YN: t
Has Association 2 Fee: No
Has Association 2 Reserve: No
Has Association Fee: Yes
Has Association Reserve: Yes
Has HOA Covenants: t
HOA 2 Transfer Fee: No
HOA Transfer Fee: Yes
HOA Website: http://JohnsonFarm@ccgcolorado.com
Garage
Attached Garage YN: t
Covered Spaces: 3
Garage Spaces: 3
Garage YN: t
Garage Sq Ft: 697
Garage Type: Attached
Basement
Basement: "Full", "Unfinished"
Bathrooms
Bathrooms Full: 2
Bathrooms Half: 1
Bathrooms Total Integer: 3
Baths Full Additional: 0
Baths Full Basement: 0
Baths Half Additional: 0
Baths Half Basement: 0
Baths Rough In: 0
Baths Three Quarters Additional: 0
Baths Three Quarters Basement: 0
Baths Three Quarters Lower: 0
Baths Three Quarters Upper: 0
Bedrooms
Bedrooms Total: 4
All Bedrooms Conform: t
Location
City: Longmont
Country: US
County Or Parish: Weld
Locale: Frederick
Latitude: 40.13711
Longitude: -104.9559
MLS Area Major: Greeley/Weld
Postal Code: 80504
State Or Province: CO
Street Name: Sequoia
Street Number: 5467
Street Suffix: Pl
Subdivision Name: JOHNSON FARM
Unparsed Address: 5467 Sequoia Pl Longmont CO 80504
Cooling
Cooling: "Central Air", "Ceiling Fan(s)"
Cooling YN: t
Utilities
Electric: "Electric", "United Power"
Gas: "Natural Gas", "Black Hills"
Is Water Meter Installed: Yes
Utilities: "Natural Gas Available", "Electricity Available"
Schools
Elementary School: Legacy
High School: Frederick
High School District: ST Vrain Dist RE 1J
Middle Or Junior School: Coal Ridge
Fence
Fencing: "Fenced"
Fireplaces
Fireplace Features: "Gas", "Gas Logs Included", "Great Room"
Fireplace YN: t
Heating
Heating: "Forced Air"
Heating YN: t
Great Room
Great Room Floor Type Code: Carpet
Great Room Level Code: Main
Family Room
Has Family Room: t
Room Family Room Features: "Carpet"
Room Family Room Level: Upper
Taxes
Has Metro Tax District: No
Tax Annual Amount: 3315
Tax Year: 2022
Water Features
Has Water Rights: No
Water Source: "City Water", "Town of Frederick"
Sitting Room
Study Floor Type Code: Carpet
Study Level Code: Upper
Interior Features
Interior Features: "Study Area", "Eat-in Kitchen", "Separate Dining Room", "Walk-In Closet(s)", "Loft"
Laundry
Laundry Features: "Main Level"
Listing
Listing Id: 993775
Listing Terms: "Cash", "Conventional", "FHA", "VA Loan"
List Price: 665000
Mls Status: Active
Special Listing Conditions: "Private Owner"
Standard Status: Active
Lot
Lot Features: "Lawn Sprinkler System", "Cul-De-Sac", "Corner Lot"
Lot Size Acres: 0.18
Lot Size Area: 7964
Lot Size Square Feet: 7964
Lot Size Units: Square Feet
Property
Parcel Number: R2401603
Possible Use: "Single Family"
Property Condition: "Not New, Previously Owned"
Property Sub Type: Residential-Detached
Property Type: Residential
View: "Foothills View"
Parking
Parking Features: "Garage Door Opener"
Second Bedroom
Room Bedroom 2 Features: "Carpet"
Room Bedroom 2 Level: Upper
Third Bedroom
Room Bedroom 3 Features: "Carpet"
Room Bedroom 3 Level: Upper
Fourth Bedroom
Room Bedroom 4 Features: "Carpet"
Room Bedroom 4 Level: Upper
Dining Room
Room Dining Room Features: "Hardwood"
Room Dining Room Level: Main
Kitchen
Room Kitchen Area: 0
Room Kitchen Features: "Hardwood"
Room Kitchen Length: 0
Room Kitchen Level: Main
Room Kitchen Width: 0
Primary Bedroom
Room Master Bathroom Features: "5 Piece Primary Bath"
Room Master Bedroom Area: 0
Room Master Bedroom Features: "Carpet"
Room Master Bedroom Length: 0
Room Master Bedroom Level: Main
Room Master Bedroom Width
Windows
Window Features: "Double Pane Windows"
Estimated monthly cost
$4,099/mo
Principal & interest
$3,539/mo
Mortgage insurance
$0/mo
Property taxes
$283/mo
Home insurance
$277/mo
HOA fees
$0/mo
Utilities
$0/mo
All calculations are estimates and provided for informational purposes only. Actual amounts may vary.
Home sale price
Outstanding mortgage
Selling with traditional agent | Selling with Unreal Estate agent | |
---|---|---|
Your total sale proceeds | $625,100 | +$19,950 $645,050 |
Seller agent commission | $19,950 (3%)* | $0 (0%) |
Buyer agent commission | $19,950 (3%)* | $19,950 (3%)* |
*Commissions are based on national averages and not intended to represent actual commissions of this property
Get $19,950 more selling your home with an Unreal Estate agent
Start free MLS listingUnreal Estate checked: May 14, 2024 at 12:08 p.m.
Data updated: Aug 7, 2023 at 3:44 p.m.
Updated January 2023: By using this website, you agree to our Terms of Service, and Privacy Policy.
Unreal Estate holds real estate brokerage licenses under the following names in multiple states and locations:
Unreal Estate LLC (f/k/a USRealty.com, LLP)
Unreal Estate LLC (f/k/a USRealty Brokerage Solutions, LLP)
Unreal Estate Brokerage LLC
Unreal Estate Inc. (f/k/a Abode Technologies, Inc. (dba USRealty.com))
Main Office Location: 1500 Conrad Weiser Parkway, Womelsdorf, PA 19567
California DRE #01527504
New York § 442-H Standard Operating Procedures
TREC: Info About Brokerage Services, Consumer Protection Notice
UNREAL ESTATE IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT.
If you are using a screen reader, or having trouble reading this website, please call Unreal Estate Customer Support for help at 1-866-534-3726
Open Monday – Friday 9:00 – 5:00 EST with the exception of holidays.
*See Terms of Service for details.