Sheena Rosenquist Real Estate Agent - St Vrain Realty LLC

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

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

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

Sheena Rosenquist listing agent for 3031 Birch St, Denver, CO - sold for $670,000 — Sold $670,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

Neighborhoods Sheena is Experienced In

Sheena's Listings and Deals

Sheena's Open Houses

$444,900

Open Sat 10AM - 12PM
- 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

Homes for Sale by City

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

Neighborhoods Sheena is Experienced In

Sheena's Listings and Deals

Sheena's Open Houses

Recently Sold

Other Experience