2457 Harlequin Pl, Johnstown, CO 80534

See all 3 Photos

Map View

Favorite

Notes

Payments

Request a Showing

2457 Harlequin Pl

Johnstown, CO 80534

FOR

SALE

$378,150

For Sale

Beds

Baths

Garage

1,182

Sq.Ft.

0.04

Acres

MLS# 9265639

Cumulative Days on Market: 12 (since April 20th, 2024) Data provided by the MLS.

Property Details

This home is estimated to complete in June! The Congaree plan has everything you need in a thoughtfully designed and quaint paired home. The front of the home with oversized patio enters to the lovely great room that looks onto the kitchen complete with eat-at kitchen granite island and white cabinets. Homeowners will appreciate the convenience of a main floor powder room and attached 2 car garage. The upper level of this home features a laundry closet, an owners suite with private bath and walk-in closet as well as a spacious second bedroom with it s own private bath and walk-in closet.

Get Directions

Print Flyer

Ask a Local Expert

Comments and Questions

*Your Name

Submit Question

Property Highlights

Price

$378,150

Property Type

Attached Dwelling

Property Sub Type

Attached Dwelling

Total Bathrooms

Year Built

2024

Acres

0.04

Location

Area

Greeley/Weld

County

Weld

Subdivision

Pintail Commons

Property Details

Condition

Under Construction

Price

$378,150

Property Sub Type

Attached Dwelling

Property Type

Attached Dwelling

Building

Levels

Two

Total Area

1,182

Community

Local Schools

Elementary School

Pioneer Ridge

High School

Roosevelt

Middle School

Milliken

School District

Johnstown-Milliken RE-5J

Interior Features

Bedrooms and Bathrooms

1/2 Bathrooms

Bedrooms

Full Bathrooms

Total Bathrooms

Rooms and Basement

Basement Features

Crawl Space

Area and Spaces

Above Grade Finished Area

1,182

Living Area

1,182

Appliances

Self Cleaning Oven, Dishwasher, Microwave, Disposal

Interior Features

Electic

Electric

Interior Features

Open Floorplan, Walk-In Closet(s), Kitchen Island

Laundry Features

Upper Level

Heating and Cooling

Heating Features

Heat Pump

Building Details

Construction

Builder

Landsea Homes

New Construction

Yes

Year Built

2024

Materials

Construction Materials

Wood/Frame, Stone, Composition Siding, Concrete

Roof

Composition

Terms

Exclusions

N/A

Special Conditions

Builder

Special Terms

Cash, Conventional, FHA, VA Loan, 1031 Exchange, USDA Loan

Taxes

HOA

HOA Fee

120.00

Tax

Tax (Annual)

$4,104

Heating, Cooling & Utilities

Green Energy

Green Certifications

HERS Rated = True

Utilities

Sewer

City Sewer, Public Sewer

Utilities

Electricity Available, Cable Available

Water Source

City Water

Lot

Acres

0.04

Lot Size

1,925

Lot Size Area Sq Ft

1,925

Parking

Covered Spaces

Garage Capacity

Homeowner's Association

Has HOA

Yes

HOA Fee Period

Monthly

Exterior Features

Patio And Porch Features

Patio

Listed by Re/max Professionals, dkrrj@aol.com, 303-930-5172.

Listing Data last updated 05/03/2024 10:30 AM

Get a Link to this Property: Copy To Clipboard

View Census Data

View Schools

Phone:

Payment Calculator

per month. Fixed. % interest.

Home Price

Down Payment

Loan Type

Interest Rate

Total interest paid over s will be:

Principal & Interest

Home Insurance

Property Tax

HOA Fees

All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 3-May-2024 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by open source mortgage calculation software tools using common mathematical formulas. Copyright © 2024 Buying Buddy. All calculations should be independantly verified.

Interest rates and APRs presented are based on current market rates, are for informational purposes only, are subject to change without notice and may be subject to pricing add-ons related to property type, loan amount, loan-to-value, credit score and other variables - call for details.
This is not a credit decision or a commitment to lend.
Depending on loan guidelines, mortgage insurance may be required
If mortgage insurance is required, the mortgage insurance premium could increase the APR and the monthly mortgage payment. Additional loan programs may be available.
APR (annual percentage rate) reflects the effective cost of your loan on a yearly basis, taking into account such items as interest, most closing costs, discount points (also referred to as "points"), and loan-origination fees. One point is 1% of the mortgage amount (e.g., $1,000 on a $100,000 loan).
Your monthly payment is not based on APR, but instead on the interest rate on your Note.
Adjustable Rate Mortgage (ARM) rates assume no increase in the financial index after the initial fixed period. ARM rates and monthly payments are subject to increase after the fixed period.
These special rates presented here are only available when you pre-qualify and are not guaranteed until lock-in.
Amounts may be rounded up. Additional fees and closing costs apply. If the down payment is less than 20%, mortgage insurance may be needed, which could increase the monthly payment and APR.
Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. This Payment Calculator tool is Copyright © 2024 Buying Buddy. All calculations should be independantly verified.
Please contact a loan specialist to get specific payment examples and information regarding your particular needs.

Get Walk Score Content

Property History

2 days ago

Property information last updated

12 days ago

Status Active. This is the date the listing was placed on market.

NOTE: Cumulative Days on Market: 12. Data provided by the MLS.

Similar Properties

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES.
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.

Listing Data last updated: 05/03/2024 10:30 AM

2457 Harlequin Pl - MLS#9265639 - $378,150

Listed by Re/max Professionals

{"property_id":"boulder_9265639","AboveGradeFinishedArea":"1182","AccessibilityFeatures":null,"Appliances":"Self Cleaning Oven, Dishwasher, Microwave, Disposal","ArchitecturalStyle":null,"AssociationAmenities":null,"AssociationFee":"120.00","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":null,"AssociationYN":"1","AttributionContact":"dkrrj@aol.com, 303-930-5172","Basement":"Crawl Space","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":null,"BuilderModel":null,"BuilderName":"Landsea Homes","BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Composition Siding, Concrete","Contingency":null,"Cooling":null,"CountyOrParish":"Weld","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric","ElementarySchool":"Pioneer Ridge","Exclusions":"N\/A","ExteriorFeatures":null,"Fencing":null,"FireplaceFeatures":null,"FireplaceYN":null,"FireplacesTotal":null,"Flooring":null,"FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":"HERS Rated = True","GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Heat Pump","HighSchool":"Roosevelt","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Open Floorplan, Walk-In Closet(s), Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Upper Level","Levels":"Two","ListingTerms":"Cash, Conventional, FHA, VA Loan, 1031 Exchange, USDA Loan","LivingArea":null,"LotFeatures":null,"LotSizeArea":"1925.00","LotSizeSquareFeet":"1925.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Milliken","Model":null,"NewConstructionYN":"1","NumberOfUnitsTotal":null,"ListOfficeKey":"21229898c6213f7f2ee5bbb307a2d063","OfficePhone":"303-799-9898","OtherParking":null,"Ownership":null,"ParkingFeatures":null,"ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Under Construction","PropertySubType":"Attached Dwelling","public_remarks":"This home is estimated to complete in June! The Congaree plan has everything you need in a thoughtfully designed and quaint paired home. The front of the home with oversized patio enters to the lovely great room that looks onto the kitchen complete with eat-at kitchen granite island and white cabinets. Homeowners will appreciate the convenience of a main floor powder room and attached 2 car garage. The upper level of this home features a laundry closet,  an owners suite with private bath and walk-in closet as well as a spacious second bedroom with it s own private bath and walk-in closet.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Johnstown-Milliken RE-5J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer, Public Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Builder","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"4104.00","Utilities":"Electricity Available, Cable Available","View":null,"ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":null,"YearBuilt":"2024","Zoning":null,"ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"2d0fba46f5b7a6ccc90a3f4a61e10984","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"9265639","acreage":null,"acres":"0.04","address":null,"address_direction":null,"address_flg":"1","address_num":"2457","agent_id":"322395","area":"Greeley\/Weld","baths_total":"3.00","bedrooms_total":"2","car_spaces":"2","city":"Johnstown","coseller_id":null,"coagent_id":null,"days_on_market":"11","finished_sqft_total":"1182","geocode_address":null,"geocode_status":null,"lat":"40.33308","lon":"-104.940842","office_id":"00230","office_name":"RE\/MAX Professionals","orig_price":"376150","photo_count":"3","previous_price":null,"price":"378150","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/edd349a0eefa24538960cb78093216de\/83dcefb7.jpeg","property_type":"Attached Dwelling","sqft_total":"1182","state":"CO","street_type":"Pl","street_name":"Harlequin","sub_area":"Pintail Commons","unit":null,"zip_code":"80534","listing_dt":"2024-04-20","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-04-30 22:30:26","create_dt":"2024-04-20 21:30:04","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}

Start of property details

Property Details

Ask a Local Expert

Property Highlights

Location

Property Details

Building

Community

Local Schools

Interior Features

Bedrooms and Bathrooms

Rooms and Basement

Area and Spaces

Appliances

Interior Features

Heating and Cooling

Building Details

Construction

Materials

Terms

Terms

Taxes

HOA

Tax

Heating, Cooling & Utilities

Green Energy

Utilities

Lot

Parking

Homeowner's Association

Exterior Features

Payment Calculator

Assumptions and Disclosures

Property History

Similar Properties