Public Remarks: THIS IS A GREAT INVESTMENT OPPORTUNITY IN A PERFECT LOCATION. BUY AN ALREADY RENTED MODEL HOME THAT CAN BE CASH POSITIVE. ALL UTILITIES, HOA, AND WATER PAID BY THE BUILDER FOR THE ENTIRE LEASE. RENT WILL BE GUARANTEED FOR ONE YEAR WITH AN OPTIONAL SECOND YEAR. THIS UNIT HAS TONS OF UPGRADES, IS BUILT GREEN, HIGHLY E-STAR RATED,AND HAS FANTASTIC VIEWS OF THE MOUNTAINS AND PLAINS.THE COMMUNITY IS LOCATED IN LONGMONT'S BEST SCHOOL DISTRICT,NEXT TO OPEN SPACE, A FUTURE PARK, AND ELEMENTARY SCHOOL.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
3
Baths
2.5
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
2007
Sq. Ft.
1,315
Year built
2007
Style
Condo/Co-op
County
Boulder County
APN
R0512218
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
PUD
Planned Unit Developments District
Planned unit developments PUDs are intended to encourage innovative site design and land use planning to provide a more creative design than would otherwise be achieved through strict application of a base zoning district. PUDs may allow greater freedom in mixes of uses within a development, and greater development densities when justified by exceptional design. In exchange for greater flexibility, PUDs are expected to include exceptional design to preserve critical environmental resources; provide above-average common areas and recreational amenities; incorporate creative design in the layout of buildings, common areas, and circulation; ensure compatibility with surrounding land uses and neighborhood character; and provide greater efficiency in the layout and provision of roads, utilities, and other infrastructure.
Permitted uses
Include but are not limited to:
No uses permitted by right
Property details
Interior
Bedroom Information
Bedrooms Total: 3
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator
Open Floorplan
Exterior
Exterior Features
Fencing: Fenced
Patio and Porch Features: Patio
Roof: Composition
Lot Information
Horse(s): No
Lot Features: Sidewalks, Lawn Sprinkler System, Abuts Park
Zoning: RES
Property Information
Property Attached: Yes
Property Type: Residential Income
Property Sub Type: Attached Dwelling
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Blue Vista
MLS Area Major: Longmont
Building Information
Builder Name: Boulder Creek Builders
Construction Materials: Wood/Frame
Financial
Tax Information
Parcel Number: R0512218
Tax Year: 2007
Lease Information
Gross Income: 13992
Gross Scheduled Income: 13992
Operating Expense: 0
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric
Gas: Natural Gas
Sewer: City Sewer
Location
Multi-Family Financial Information
Cap Rate: 6.99
Net Operating Income: 13992
Tenant Pays: Gas, Electricity, Taxes, Association Fees
HOA Information
Association: No
Association Fee: 0
Association Fee Includes: Common Amenities, Trash, Snow Removal, Management, Utilities, Maintenance Structure
Community Features: Playground
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Burlington
Middle or Junior School: Sunset Middle
High School: Niwot
Location Information
Directions: Main Street/87 to Quail Road, East on Quail past Longmont Rec Center to Model home and Sales office on the Right (about 1/2 mile).
Unparsed Address: 117 Quail Rd B Longmont CO 80501
Street Number: 117
Street Name: Quail
Street Suffix: Rd
UnitNumber: B
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80501
Coordinates: -105.098179,40.145153
Latitude: 40.145153
Longitude: -105.098179
Public facts
Beds: 3
Baths: 2.5
Sq. Ft.: 1,315
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: 2007
Year Renovated: 2007
County: Boulder County
APN: R0512218
Home facts updated by county records on Sep 2, 2026
Other
Documents & Disclosures
Documents Available: Soil Test Available
Documents Count: 1
Listing Information
Attribution Contact: 3032451000
Close Price: $193,000
Photos Count: 9
Possible Use: Single Family
Special Listing Conditions: Other Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, April 27, 2007
Cumulative Days on Market: 55
Days on Market: 55
Listing Contract Date: Wednesday, March 7, 2007
Modification Timestamp: Wednesday, November 6, 2024 4:45 AM
Home Information
Levels: Three Or More
New Construction: Yes
Window Features: Window Coverings, Double Pane Windows
Year Built: 2007
Green Information
Green Energy Efficient: Southern Exposure, HVAC, Energy Survey Complete, Thermostat, Energy Rated
Around this home
Schools
Burlington Elementary School
Public PreK-5 • Assigned • 0.7mi
5/10
Sunset Middle School
Public 6-8 • Assigned • 1.3mi
6/10
Niwot High School
Public 9-12 • Assigned • 3.9mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
A vibrant northern Colorado community known for its scenic mountain views, extensive parks and trails, greenways, and a mix of established neighborhoods and newer housing options.