Photo 1 of 39 of 5467 Sequoia Pl house
Photo 2 of 39 of 5467 Sequoia Pl house
Photo 3 of 39 of 5467 Sequoia Pl house
Photo 4 of 39 of 5467 Sequoia Pl house
Photo 5 of 39 of 5467 Sequoia Pl house
Photo 6 of 39 of 5467 Sequoia Pl house
Photo 7 of 39 of 5467 Sequoia Pl house
Photo 8 of 39 of 5467 Sequoia Pl house
Photo 9 of 39 of 5467 Sequoia Pl house
Photo 10 of 39 of 5467 Sequoia Pl house
Photo 11 of 39 of 5467 Sequoia Pl house
Photo 12 of 39 of 5467 Sequoia Pl house
Photo 13 of 39 of 5467 Sequoia Pl house
Photo 14 of 39 of 5467 Sequoia Pl house
Photo 15 of 39 of 5467 Sequoia Pl house
Photo 16 of 39 of 5467 Sequoia Pl house
Photo 17 of 39 of 5467 Sequoia Pl house
Photo 18 of 39 of 5467 Sequoia Pl house
Photo 19 of 39 of 5467 Sequoia Pl house
Photo 20 of 39 of 5467 Sequoia Pl house
Photo 21 of 39 of 5467 Sequoia Pl house
Photo 22 of 39 of 5467 Sequoia Pl house
Photo 23 of 39 of 5467 Sequoia Pl house
Photo 24 of 39 of 5467 Sequoia Pl house
Photo 25 of 39 of 5467 Sequoia Pl house
Photo 26 of 39 of 5467 Sequoia Pl house
Photo 27 of 39 of 5467 Sequoia Pl house
Photo 28 of 39 of 5467 Sequoia Pl house
Photo 29 of 39 of 5467 Sequoia Pl house
Photo 30 of 39 of 5467 Sequoia Pl house
Photo 31 of 39 of 5467 Sequoia Pl house
Photo 32 of 39 of 5467 Sequoia Pl house
Photo 33 of 39 of 5467 Sequoia Pl house
Photo 34 of 39 of 5467 Sequoia Pl house
Photo 35 of 39 of 5467 Sequoia Pl house
Photo 36 of 39 of 5467 Sequoia Pl house
Photo 37 of 39 of 5467 Sequoia Pl house
Photo 38 of 39 of 5467 Sequoia Pl house
Photo 39 of 39 of 5467 Sequoia Pl house
  • Overview

  • Monthly cost

  • Get pre-approved

  • Fees & commissions

  • Related

  • Intelligence reports

Save

Active

Buy a houseat 5467 Sequoia Pl, Longmont, CO 80504

$665,000

$0/mo

Get pre-approved

Residential

2,782 Sq. Ft.

7,964 Sq. Ft. lot

4 Bedrooms

3 Bathrooms

282 Days on market

993775 MLS ID

Click to interact

Property position on map

Click the map to interact

About 5467 Sequoia Pl house

Welcome to this immaculate and inviting home offering a generous 2,782 square feet of finished living space with even more potential in the full unfinished basement. The great room with a gas fireplace is designed to be a warm and welcoming place for gatherings or just relaxing. The kitchen is tastefully appointed with granite counters, stylish cabinetry and eating area. The versatile dining room can be easily transformed into a study or music room. The main floor boasts a primary bedroom complete with an ensuite bathroom. Enjoy the convenience of the walk-in closet making organization a breeze. Upstairs, you'll discover the perfect balance of practicality and versatility. You will be impressed by the expansive loft area with mountain views offering endless possibilities for an entertainment space, office or play area. Adjacent to the loft is a bonus room providing a quiet haven for work or exercise. Additionally, the upper-level features three large bedrooms each designed for comfort. A full bath on this level ensures convenience and ease for everyone. The main floor laundry room is a plus. Brand new roof. This home has the combinations of a 3-car garage, corner lot advantages, and well-designed living spaces for you to appreciate. You will have a wonderful place to call your own, offering both comfort and functionality for you and your family to create lasting memories. This Home is Ready to Move In and Enjoy!
Welcome to this immaculate and inviting home offering a generous 2,782 square feet of finished living space with even more potential in the full unfinished basement. The great room with a gas fireplace is designed to be a warm and welcoming place for gatherings or just relaxing. The kitchen is tastefully appointed with granite counters, stylish cabinetry and eating area. The versatile dining room can be easily transformed into a study or music room. The main floor boasts a primary bedroom complete with an ensuite bathroom. Enjoy the convenience of the walk-in closet making organization a breeze. Upstairs, you'll discover the perfect balance of practicality and versatility. You will be impressed by the expansive loft area with mountain views offering endless possibilities for an entertainment space, office or play area. Adjacent to the loft is a bonus room providing a quiet haven for work or exercise. Additionally, the upper-level features three large bedrooms each designed for comfort. A full bath on this level ensures convenience and ease for everyone. The main floor laundry room is a plus. Brand new roof. This home has the combinations of a 3-car garage, corner lot advantages, and well-designed living spaces for you to appreciate. You will have a wonderful place to call your own, offering both comfort and functionality for you and your family to create lasting memories. This Home is Ready to Move In and Enjoy!

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"

Monthly cost

Estimated monthly cost

$4,099/mo

All calculations are estimates and provided for informational purposes only. Actual amounts may vary.

Seller fees & commissions

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 listing
View related pages

State

  • Mobile Homes for sale in Colorado
  • Real Estate for Sale in Colorado

Unreal Estate checked: May 14, 2024 at 12:08 p.m.

Data updated: Aug 7, 2023 at 3:44 p.m.

Courtesy of Connie Quinn, Coldwell Banker Realty-N Metro 3032350400
This content last updated on 08/07/2023. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Provided for limited non-commercial use only under IRES Rules. Listing information is provided exclusively for consumers' 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 deemed reliable but not guaranteed by the MLS.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © IRES 2024. All Rights Reserved.

Learn more about this property

Request edits for this property

By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from unrealestate.com and others about your inquiry and other home related matters, but not as a condition of any purchase.
*By checking this box, I confirm that I am the legal owner of the property listed. Please note, all information is verified for accuracy per U.S. real estate regulations, and submissions from non-owners cannot be processed.

Properties near 5467 Sequoia Pl

Unreal Estate stacked logo

About

BuySellMortgageAgentsCompany

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 ServicesConsumer 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.

LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon

© 2023 Unreal Estate Inc. All Rights Reserved.

Unreal Estate certified trust badge
LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon