Sheena Rosenquist Real Estate Agent - St Vrain Realty LLC

1101 Shelby Dr, Berthoud, CO For Sale $1,350,000 - listed by Sheena Rosenquist — For Sale $1,350,000

Sheena Rosenquist listing agent for 160 7th St, Frederick, CO - sold for $365,000 — Sold $365,000

954 Martin Rd, Longmont, CO For Sale $444,900 - listed by Sheena Rosenquist — For Sale $444,900

Sheena Rosenquist buyer's agent for 14 S Gay Dr, Longmont, CO - sold for $490,000 — Sold $490,000

Sheena Rosenquist

Longmont CO

St Vrain Realty LLC

23 Closed Sales

$12.8M Total Value

$430K - $1.1M Price Range

$557K Average Price

Prior 5 years

About Sheena

Home Types: House, Townhouse

Years of Experience: 4

Transaction History

1 Year
2 Year
5 Year

Seller Deals
Total Deals	7
Total Value	$4,006,500
Average Sale Price	$572,357
Price Range	$365K - $856K

Buyer Deals
Total Deals	3
Total Value	$1,503,000
Average Sale Price	$501,000
Price Range	$488K - $525K

1 Year View by Quarter

Seller Deals
Total Deals	11
Total Value	$6,735,990
Average Sale Price	$612,363
Price Range	$365K - $1.1M

Buyer Deals
Total Deals	7
Total Value	$3,354,500
Average Sale Price	$479,214
Price Range	$317K - $575K

2 Year View by Quarter

Seller Deals
Total Deals	12
Total Value	$7,335,990
Average Sale Price	$611,333
Price Range	$365K - $1.1M

Buyer Deals
Total Deals	11
Total Value	$5,474,400
Average Sale Price	$497,673
Price Range	$317K - $575K

5 Year View

Areas Sheena is Experienced In

Sheena's Listings and Deals

Sheena's Open Houses

$1,350,000

Open Sat 12:30PM - 2:30PM
- 4 Beds
- 3.5 Baths
- 5,266 Sq Ft
1101 Shelby Dr

Berthoud, CO
Set on two acres in Rainbow Lake Estates near Carter Lake, this expansive ranch brings together generous main-level living, quality craftsmanship, mountain views, and a beautifully established outdoor setting. Offered for the first time by its original owners, the home has been exceptionally well cared for, with thoughtful materials and attention to detail evident throughout. Inside, bright, open

Sheena Rosenquist St Vrain Realty LLC

$444,900

Open Sat 9AM - 11AM
- 2 Beds
- 1 Bath
- 1,008 Sq Ft
954 Martin Rd

Longmont, CO
Beautifully updated, this single-level Longmont ranch features a fully remodeled kitchen and bathroom, new LVP flooring, fresh interior and exterior paint, and a dedicated 12x24 workshop. The open-concept kitchen, dining, and living area centers around a large kitchen island, with new cabinetry, quartz countertops, all-new stainless steel appliances, updated lighting, and plenty of natural light.

Sheena Rosenquist St Vrain Realty LLC

Recently Sold

$365,000

Sold Aug 11, 2026
- 3 Beds
- 1.5 Baths
- 1,474 Sq Ft
160 7th St

Frederick, CO
- 6% Below List
- 51 Days On Market
- $248/SF
- Current Est. Value $388K
Sheena Rosenquist St Vrain Realty LLC

$670,000

Sold Jan 9, 2026
- 4 Beds
- 2 Baths
- 2,158 Sq Ft
3031 Birch St

Denver, CO
- 3 Days On Market
- $310/SF
- Current Est. Value $685K
Sheena Rosenquist St Vrain Realty LLC

$475,300

Sold Dec 29, 2025
- 4 Beds
- 3 Baths
- 1,885 Sq Ft
615 Sumac St

Frederick, CO
- 2% Below List
- 25 Days On Market
- $252/SF
- Current Est. Value $477K
Sheena Rosenquist St Vrain Realty LLC

$539,000

Sold Nov 21, 2025
- 5 Beds
- 3 Baths
- 3,108 Sq Ft
11449 Coal Ridge St

Firestone, CO
- 5% Below List
- 41 Days On Market
- $173/SF
- Current Est. Value $555K
Sheena Rosenquist St Vrain Realty LLC

$856,000

Sold Sep 15, 2025
- 6 Beds
- 5.5 Baths
- 4,862 Sq Ft
797 Flora View Dr

Erie, CO
- 4% Below List
- 22 Days On Market
- $176/SF
- Current Est. Value $1M
Sheena Rosenquist St Vrain Realty LLC

$1,060,000

Sold Apr 30, 2025
- 4 Beds
- 3.5 Baths
- 3,832 Sq Ft
1935 Diamond Dr

Longmont, CO
- 2% Below List
- 55 Days On Market
- $277/SF
- Current Est. Value $1M
Sheena Rosenquist St Vrain Realty LLC

$551,990

Sold Feb 14, 2025
- 4 Beds
- 3 Baths
- 3,182 Sq Ft
11732 Lewiston St

Commerce City, CO
- 1% Below List
- 92 Days On Market
- $173/SF
- Current Est. Value $565K
Sheena Rosenquist St Vrain Realty LLC

$430,000

Sold Jan 13, 2025
- 2 Beds
- 1 Bath
- 1,060 Sq Ft
1209 Grant St

Longmont, CO
- 31 Days On Market
- $406/SF
- Current Est. Value $440K
Sheena Rosenquist St Vrain Realty LLC

$687,500

Sold Jul 19, 2024
- 4 Beds
- 2.5 Baths
- 3,922 Sq Ft
633 Americana Rd

Longmont, CO
- 2% Above List
- 2 Days On Market
- $175/SF
- Current Est. Value $719K
Sheena Rosenquist St Vrain Realty LLC

Other Experience

First Time Homebuyers, Veteran's Programs, Luxury Homes, New Construction, Foreclosures

Agent License: Colorado 100097188

Sheena Rosenquist

(833) 657-0318

St Vrain Realty LLC

(833) 657-0318

Nearby Homes

Sheena Rosenquist

About Sheena

Transaction History

Seller Deals

Buyer Deals

Production Over Time

1 Year View by Quarter

Seller Deals

Buyer Deals

Production Over Time

2 Year View by Quarter

Seller Deals

Buyer Deals

Production Over Time

5 Year View

Areas Sheena is Experienced In

Sheena's Listings and Deals

Sheena's Open Houses

Recently Sold

Other Experience