Property Details
Start of property details
4236 Frederick Circle
Longmont, CO 80503
FOR
SALE
$939,900
Active
5
Beds
4
Baths
3
Garage
3,845
Sq.Ft.
0.15
Acres
MLS# 5402928
Cumulative Days on Market: 11
(since
May 10th, 2025)
Data provided by the MLS.
Property Description
OPEN HOUSE Sat 5 / 10 2-4 and Sun 5 / 11 12-3 🙂 Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring gleaming hardwood floors, a main level bedroom with a full bath, and a gourmet kitchen boasting custom upgraded finishes. The open floor plan flows seamlessly into the dining and living areas, perfect for everyday living and entertaining.Upstairs, the expansive primary suite is a true retreat with two walk-in closets and a luxurious ensuite bath. You'll also find a bright and airy loft, two additional bedrooms connected by a Jack and Jill bathroom, and a convenient laundry room with beautiful custom cabinetry.The professionally finished basement is a showstopper, complete with a high-end wet bar, multiple storage areas, and a private guest suite with a large bedroom and 3 / 4 bath-ideal for visiting friends or multigenerational living.Enjoy outdoor living year-round on the covered front and back patios, surrounded by landscaping and a tranquil water feature for added serenity. Not to be overlooked is the split 3 car garage (2 on one side - 1 on the other) Don't miss the opportunity to own this exceptional home in one of Longmont's most desirable neighborhoods. Schedule your showing today!
Property Highlights
Price
$939,900
Property Type
Residential
Architectural Style
Contemporary
Bedrooms
5
Total Bathrooms
4
Living Area
3,636
Price / Sq Ft
$258
Acres
0.15
Year Built
2007
Condition
Updated/Remodeled
Location
County
Boulder
Subdivision
Reserve at Renaissance
Property Details
Condition
Updated/Remodeled
Price
$939,900
Property Type
Residential
Building
Levels
Two
Structure Type
House
Total Area
3,845
Community
Local Schools
Elementary School
Eagle Crest
High School
Silver Creek
Middle School
Altona
School District
St. Vrain Valley RE-1J
Interior Features
Bedrooms and Bathrooms
3/4 Bathrooms
1
Bathrooms on Main Level
1
Bedrooms
5
Bedrooms on Main Level
1
Full Bathrooms
3
Total Bathrooms
4
Rooms and Basement
Basement Features
Finished, Full
Has Basement
Yes
Area and Spaces
Above Grade Finished Area
2,645
Below Grade Finished Area
991
Appliances
Appliances
Bar Fridge, Cooktop, Dishwasher, Disposal, Dryer, Electric Water Heater, Microwave, Oven, Refrigerator, Washer
Interior Features
Fireplace Features
Great Room
Flooring
Carpet, Tile, Wood
Interior Features
Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, In-Law Floorplan, Jack & Jill Bathroom, Kitchen Island, Pantry, Primary Suite, Smoke Free, Walk-In Closet(s), Wet Bar
Laundry Features
In Unit
Window Features
Double Pane Windows, Egress Windows, Window Coverings
Heating and Cooling
Fireplaces
1
Heating Features
Forced Air
Building Details
Construction
Architectural Style
Contemporary
Foundations
Slab
Year Built
2007
Materials
Construction Materials
Frame
Roof
Shingle
Terms
Terms
Exclusions
none
Ownership
Individual
Special Conditions
None
Special Terms
Cash, Conventional, VA Loan
Taxes
HOA
Association Ammenities
Park
Association Fee
$204
Association Fee Frequency
Quarterly
Has HOA
Yes
Tax
Tax (Annual)
$5,009
Heating, Cooling & Utilities
Cooling Features
Central Air
Utilities
Sewer
Public Sewer
Utilities
Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected
Water Source
Public
Lot
Acres
0.15
Lot Size
6,424
Lot Size Area Sq Ft
6,424
Exterior Features
Exterior Features
Fire Pit, Garden
Patio And Porch Features
Covered, Deck, Front Porch, Patio
Parking
Total Parking Spaces
3
Listed by Neuhaus Real Estate, Inc., april@aprilneuhaus.com, 970-213-9394.
Listing Data last updated 05/21/2025 05:00 pm
Get a Link to this Property: Copy To Clipboard
Phone:
Payment Calculator
per month.
fixed.
% interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
Total interest paid over s will be:
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 21-May-2025 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. All calculations should be independently verified.
Get Walk Score Content
Property History
Yesterday
Property information last updated
11 days ago
Status Active. This is the date the listing was placed on market.
NOTE: Cumulative Days on Market: 11.
Data provided by the MLS.
Similar Properties
Listings courtesy of REcolorado as distributed by MLS GRID. IDX 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. Data is deemed reliable but is not guaranteed by MLS GRID. Based on information submitted to the MLS GRID as of 05/21/2025 05:00 pm. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
Listing Data last updated: 05/21/2025 05:00 pm
Service by
Buying Buddy® IDX CRM
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.
Listed by Neuhaus Real Estate, Inc.
{"property_id":"denver_5402928","AboveGradeFinishedArea":"2645","AccessibilityFeatures":"","Appliances":"Bar Fridge, Cooktop, Dishwasher, Disposal, Dryer, Electric Water Heater, Microwave, Oven, Refrigerator, Washer","ArchitecturalStyle":"Contemporary","AssociationAmenities":"Park","AssociationFee":"204.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"","AssociationYN":"1","AttributionContact":"april@aprilneuhaus.com, 970-213-9394","Basement":"Finished, Full","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"991","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","BuyerFinancing":"","CapRate":"0.00","CityRegion":"","CommonInterest":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Frame","Contingency":"","Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":"0","CurrentFinancing":"","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"Eagle Crest","Exclusions":"none","ExteriorFeatures":"Fire Pit, Garden","Fencing":"","FireplaceFeatures":"Great Room","FireplaceYN":"","FireplacesTotal":"1","Flooring":"Carpet, Tile, Wood","FoundationDetails":"Slab","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Forced Air","HighSchool":"Silver Creek","HorseAmenities":"","HorseYN":"","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, In-Law Floorplan, Jack & Jill Bathroom, Kitchen Island, Pantry, Primary Suite, Smoke Free, Walk-In Closet(s), Wet Bar","InternetAddressDisplayYN":"","LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"April Neuhaus","ListAgentEmail":"","ListingTerms":"Cash, Conventional, VA Loan","LivingArea":"0.00","LotFeatures":"","LotSizeArea":"6424.00","LotSizeDimensions":"","LotSizeSquareFeet":"6424.00","MainLevelBathrooms":"1","MainLevelBedrooms":"1","MiddleOrJuniorSchool":"Altona","Model":"","NewConstructionYN":"","NumberOfUnitsTotal":"0","OtherParking":"","Ownership":"Individual","ParkingFeatures":"","ParkingTotal":"3","PatioAndPorchFeatures":"Covered, Deck, Front Porch, Patio","PoolFeatures":"","PoolYN":"","PoolPrivateYN":"","PropertyAttachedYN":"0","PropertyCondition":"Updated\/Remodeled","public_remarks":"OPEN HOUSE Sat 5\/10 2-4 & Sun 5\/11 12-3 :) Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring gleaming hardwood floors, a main level bedroom with a full bath, and a gourmet kitchen boasting custom upgraded finishes. The open floor plan flows seamlessly into the dining and living areas, perfect for everyday living and entertaining.Upstairs, the expansive primary suite is a true retreat with two walk-in closets and a luxurious ensuite bath. You'll also find a bright and airy loft, two additional bedrooms connected by a Jack & Jill bathroom, and a convenient laundry room with beautiful custom cabinetry.The professionally finished basement is a showstopper, complete with a high-end wet bar, multiple storage areas, and a private guest suite with a large bedroom and 3\/4 bath-ideal for visiting friends or multigenerational living.Enjoy outdoor living year-round on the covered front and back patios, surrounded by landscaping and a tranquil water feature for added serenity. Not to be overlooked is the split 3 car garage (2 on one side - 1 on the other) Don't miss the opportunity to own this exceptional home in one of Longmont's most desirable neighborhoods. Schedule your showing today!","Roof":"Shingle","RoomsTotal":"0","SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"","SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":"","SpaFeatures":"","SpaYN":"","SpecialListingConditions":"None","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"House","TaxAnnualAmount":"5009.00","Utilities":"Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected","View":"","ViewYN":"","VirtualTourURLUnbranded":"","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"","WindowFeatures":"Double Pane Windows, Egress Windows, Window Coverings","YearBuilt":"2007","Zoning":"","ZoningDescription":"","property_uid":"REC2046743443","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"5402928","acreage":"","acres":"0.15","address":"","address_direction":"","address_flg":"1","address_num":"4236","agent_id":"019508","area":"","baths_total":"4.00","bedrooms_total":"5","car_spaces":"3","city":"Longmont","coseller_id":"","coagent_id":"","days_on_market":"0","finished_sqft_total":"3636","geocode_address":"4236 Frederick Circle","geocode_status":"","lat":"40.13695357","lon":"-105.1584508","map_flg":"true","office_id":"M2645","office_name":"Neuhaus Real Estate, Inc.","orig_price":"939900","photo_count":"50","previous_price":"0","price":"939900","prop_img":"\/listing\/photos\/denver\/5402928-0.jpeg","property_type":"Residential","property_subtype":"Single Family Residence","sqft_total":"3845","state":"CO","street_type":"Circle","street_name":"Frederick","sub_area":"Reserve at Renaissance","unit":"","zip_code":"80503","listing_dt":"0000-00-00","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"0000-00-00","sold_price":"0","webapi_update_dt":"2025-05-11 21:05:23","update_dt":"2025-05-20 00:19:27","create_dt":"2025-05-10 02:02:24","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}
Start of property details
4236 Frederick Circle
Longmont, CO 80503
FOR
SALE
$939,900
Active
5
Beds
4
Baths
3
Garage
3,845
Sq.Ft.
0.15
Acres
MLS# 5402928
Cumulative Days on Market: 11
(since
May 10th, 2025)
Data provided by the MLS.
Property Description
OPEN HOUSE Sat 5 / 10 2-4 and Sun 5 / 11 12-3 🙂 Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring gleaming hardwood floors, a main level bedroom with a full bath, and a gourmet kitchen boasting custom upgraded finishes. The open floor plan flows seamlessly into the dining and living areas, perfect for everyday living and entertaining.Upstairs, the expansive primary suite is a true retreat with two walk-in closets and a luxurious ensuite bath. You'll also find a bright and airy loft, two additional bedrooms connected by a Jack and Jill bathroom, and a convenient laundry room with beautiful custom cabinetry.The professionally finished basement is a showstopper, complete with a high-end wet bar, multiple storage areas, and a private guest suite with a large bedroom and 3 / 4 bath-ideal for visiting friends or multigenerational living.Enjoy outdoor living year-round on the covered front and back patios, surrounded by landscaping and a tranquil water feature for added serenity. Not to be overlooked is the split 3 car garage (2 on one side - 1 on the other) Don't miss the opportunity to own this exceptional home in one of Longmont's most desirable neighborhoods. Schedule your showing today!
Property Highlights
Price
$939,900
Property Type
Residential
Architectural Style
Contemporary
Bedrooms
5
Total Bathrooms
4
Living Area
3,636
Price / Sq Ft
$258
Acres
0.15
Year Built
2007
Condition
Updated/Remodeled
Location
County
Boulder
Subdivision
Reserve at Renaissance
Property Details
Condition
Updated/Remodeled
Price
$939,900
Property Type
Residential
Building
Levels
Two
Structure Type
House
Total Area
3,845
Community
Local Schools
Elementary School
Eagle Crest
High School
Silver Creek
Middle School
Altona
School District
St. Vrain Valley RE-1J
Interior Features
Bedrooms and Bathrooms
3/4 Bathrooms
1
Bathrooms on Main Level
1
Bedrooms
5
Bedrooms on Main Level
1
Full Bathrooms
3
Total Bathrooms
4
Rooms and Basement
Basement Features
Finished, Full
Has Basement
Yes
Area and Spaces
Above Grade Finished Area
2,645
Below Grade Finished Area
991
Appliances
Appliances
Bar Fridge, Cooktop, Dishwasher, Disposal, Dryer, Electric Water Heater, Microwave, Oven, Refrigerator, Washer
Interior Features
Fireplace Features
Great Room
Flooring
Carpet, Tile, Wood
Interior Features
Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, In-Law Floorplan, Jack & Jill Bathroom, Kitchen Island, Pantry, Primary Suite, Smoke Free, Walk-In Closet(s), Wet Bar
Laundry Features
In Unit
Window Features
Double Pane Windows, Egress Windows, Window Coverings
Heating and Cooling
Fireplaces
1
Heating Features
Forced Air
Building Details
Construction
Architectural Style
Contemporary
Foundations
Slab
Year Built
2007
Materials
Construction Materials
Frame
Roof
Shingle
Terms
Terms
Exclusions
none
Ownership
Individual
Special Conditions
None
Special Terms
Cash, Conventional, VA Loan
Taxes
HOA
Association Ammenities
Park
Association Fee
$204
Association Fee Frequency
Quarterly
Has HOA
Yes
Tax
Tax (Annual)
$5,009
Heating, Cooling & Utilities
Cooling Features
Central Air
Utilities
Sewer
Public Sewer
Utilities
Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected
Water Source
Public
Lot
Acres
0.15
Lot Size
6,424
Lot Size Area Sq Ft
6,424
Exterior Features
Exterior Features
Fire Pit, Garden
Patio And Porch Features
Covered, Deck, Front Porch, Patio
Parking
Total Parking Spaces
3
Listed by Neuhaus Real Estate, Inc., april@aprilneuhaus.com, 970-213-9394.
Listing Data last updated 05/21/2025 05:00 pm
Get a Link to this Property: Copy To Clipboard
Phone:
Payment Calculator
per month.
fixed.
% interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
Total interest paid over s will be:
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 21-May-2025 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. All calculations should be independently verified.
Get Walk Score Content
Property History
Yesterday
Property information last updated
11 days ago
Status Active. This is the date the listing was placed on market.
NOTE: Cumulative Days on Market: 11.
Data provided by the MLS.
Similar Properties
Listings courtesy of REcolorado as distributed by MLS GRID. IDX 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. Data is deemed reliable but is not guaranteed by MLS GRID. Based on information submitted to the MLS GRID as of 05/21/2025 05:00 pm. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
Listing Data last updated: 05/21/2025 05:00 pm
Service by
Buying Buddy® IDX CRM
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.
Listed by Neuhaus Real Estate, Inc.
{"property_id":"denver_5402928","AboveGradeFinishedArea":"2645","AccessibilityFeatures":"","Appliances":"Bar Fridge, Cooktop, Dishwasher, Disposal, Dryer, Electric Water Heater, Microwave, Oven, Refrigerator, Washer","ArchitecturalStyle":"Contemporary","AssociationAmenities":"Park","AssociationFee":"204.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"","AssociationYN":"1","AttributionContact":"april@aprilneuhaus.com, 970-213-9394","Basement":"Finished, Full","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"991","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","BuyerFinancing":"","CapRate":"0.00","CityRegion":"","CommonInterest":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Frame","Contingency":"","Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":"0","CurrentFinancing":"","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"Eagle Crest","Exclusions":"none","ExteriorFeatures":"Fire Pit, Garden","Fencing":"","FireplaceFeatures":"Great Room","FireplaceYN":"","FireplacesTotal":"1","Flooring":"Carpet, Tile, Wood","FoundationDetails":"Slab","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Forced Air","HighSchool":"Silver Creek","HorseAmenities":"","HorseYN":"","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, In-Law Floorplan, Jack & Jill Bathroom, Kitchen Island, Pantry, Primary Suite, Smoke Free, Walk-In Closet(s), Wet Bar","InternetAddressDisplayYN":"","LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"April Neuhaus","ListAgentEmail":"","ListingTerms":"Cash, Conventional, VA Loan","LivingArea":"0.00","LotFeatures":"","LotSizeArea":"6424.00","LotSizeDimensions":"","LotSizeSquareFeet":"6424.00","MainLevelBathrooms":"1","MainLevelBedrooms":"1","MiddleOrJuniorSchool":"Altona","Model":"","NewConstructionYN":"","NumberOfUnitsTotal":"0","OtherParking":"","Ownership":"Individual","ParkingFeatures":"","ParkingTotal":"3","PatioAndPorchFeatures":"Covered, Deck, Front Porch, Patio","PoolFeatures":"","PoolYN":"","PoolPrivateYN":"","PropertyAttachedYN":"0","PropertyCondition":"Updated\/Remodeled","public_remarks":"OPEN HOUSE Sat 5\/10 2-4 & Sun 5\/11 12-3 :) Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring gleaming hardwood floors, a main level bedroom with a full bath, and a gourmet kitchen boasting custom upgraded finishes. The open floor plan flows seamlessly into the dining and living areas, perfect for everyday living and entertaining.Upstairs, the expansive primary suite is a true retreat with two walk-in closets and a luxurious ensuite bath. You'll also find a bright and airy loft, two additional bedrooms connected by a Jack & Jill bathroom, and a convenient laundry room with beautiful custom cabinetry.The professionally finished basement is a showstopper, complete with a high-end wet bar, multiple storage areas, and a private guest suite with a large bedroom and 3\/4 bath-ideal for visiting friends or multigenerational living.Enjoy outdoor living year-round on the covered front and back patios, surrounded by landscaping and a tranquil water feature for added serenity. Not to be overlooked is the split 3 car garage (2 on one side - 1 on the other) Don't miss the opportunity to own this exceptional home in one of Longmont's most desirable neighborhoods. Schedule your showing today!","Roof":"Shingle","RoomsTotal":"0","SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"","SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":"","SpaFeatures":"","SpaYN":"","SpecialListingConditions":"None","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"House","TaxAnnualAmount":"5009.00","Utilities":"Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected","View":"","ViewYN":"","VirtualTourURLUnbranded":"","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"","WindowFeatures":"Double Pane Windows, Egress Windows, Window Coverings","YearBuilt":"2007","Zoning":"","ZoningDescription":"","property_uid":"REC2046743443","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"5402928","acreage":"","acres":"0.15","address":"","address_direction":"","address_flg":"1","address_num":"4236","agent_id":"019508","area":"","baths_total":"4.00","bedrooms_total":"5","car_spaces":"3","city":"Longmont","coseller_id":"","coagent_id":"","days_on_market":"0","finished_sqft_total":"3636","geocode_address":"4236 Frederick Circle","geocode_status":"","lat":"40.13695357","lon":"-105.1584508","map_flg":"true","office_id":"M2645","office_name":"Neuhaus Real Estate, Inc.","orig_price":"939900","photo_count":"50","previous_price":"0","price":"939900","prop_img":"\/listing\/photos\/denver\/5402928-0.jpeg","property_type":"Residential","property_subtype":"Single Family Residence","sqft_total":"3845","state":"CO","street_type":"Circle","street_name":"Frederick","sub_area":"Reserve at Renaissance","unit":"","zip_code":"80503","listing_dt":"0000-00-00","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"0000-00-00","sold_price":"0","webapi_update_dt":"2025-05-11 21:05:23","update_dt":"2025-05-20 00:19:27","create_dt":"2025-05-10 02:02:24","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}