Melissa Hems Real Estate Agent - Crystal Coleman Realty LLC

171 Hill St, Troy, NY For Sale $2,700,000 - co-listed by Melissa Hems — For Sale $2,700,000 • Co-Listing Agent

Melissa Hems listing agent for 111 Hollywood Ave, Albany, NY - sold for $415,000 — Sold $415,000

3 Minnowbrook Ave Unit A, Delmar, NY For Rent $2,150/month - listed by Melissa Hems — For Rent $2,150/month

603 1st St, Watervliet, NY Pending $299,900 - listed by Melissa Hems — Pending $299,900

Melissa Hems buyer's agent for 411 Elk St, Albany, NY - sold for $160,000 — Sold $160,000

Melissa Hems

Responds Quickly

East Greenbush NY

Crystal Coleman Realty LLC

182 Closed Sales

$52.4M Total Value

$145K - $967.5K Price Range

$288K Average Price

Prior 5 years

About Melissa

Melissa brings over 25 years of powerhouse marketing and sales experience to the Capital Region real estate scene. A top producer in both residential and commercial markets, she’s earned countless awards for her record-breaking results. Her passion? Helping clients crush their real estate goals — from landing the perfect dream home to scoring the best deal on a sale or navigating complex commercial transactions. Known for her energy, expertise, and dedication, Melissa makes every deal a winning one.

Home Types: House, Multifamily, Lot/Land, Townhouse, Condo, Commercial

Years of Experience: 17

Transaction History

1 Year
2 Year
5 Year

Seller Deals
Total Deals	14
Total Value	$4,352,800
Average Sale Price	$310,914
Price Range	$148K - $739K

Buyer Deals
Total Deals	8
Total Value	$2,526,000
Average Sale Price	$315,750
Price Range	$160K - $560K

1 Year View by Quarter

Seller Deals
Total Deals	37
Total Value	$10,711,997
Average Sale Price	$289,513
Price Range	$15K - $739K

Buyer Deals
Total Deals	15
Total Value	$4,140,000
Average Sale Price	$276,000
Price Range	$160K - $560K

2 Year View by Quarter

Seller Deals
Total Deals	125
Total Value	$36,743,247
Average Sale Price	$293,946
Price Range	$5K - $968K

Buyer Deals
Total Deals	57
Total Value	$15,681,398
Average Sale Price	$275,112
Price Range	$25K - $570K

5 Year View

Neighborhoods Melissa is Experienced In

Melissa's Listings and Deals

Melissa's Open Houses

$824,900
- 4 Beds
- 3.5 Baths
- 3,300 Sq Ft
186 Van Rensselaer Blvd

Albany, NY
NEW Price & Open Sunday 8/23/26 11-12:30PM. Executive Custom Home Adjacent to Wolfert's Roost Country Club. A rare opportunity to own this residence on 1.5 private acres bordering the prestigious Wolfert's Roost Country Club & Golf Course. Surrounded by mature trees, landscaped grounds, and a charming gazebo, this property offers a serene estate-like setting just minutes from Albany. ALL BRAND

Melissa Hems Crystal Coleman Realty LLC

Melissa's Recent Active Listings

Co-Listing Agent

$2,700,000
- 27 Beds
- 24 Baths
- 5,488 Sq Ft
171 Hill St

Troy, NY
Welcome to Hill Street, a unique commercial investment package, this well-maintained commercial asset is currently used as Veterans community living(but not exclusively for veterans)which provides a rare opportunity to own a high-performing investment in a growing area. The primary property features 22 private rooms, each with its own bathroom, providing privacy and comfort for residents. Shared

Melissa Hems Crystal Coleman Realty LLC

Co-Listing Agent

$750,000
- 4 Beds
- 2.5 Baths
- 3,000 Sq Ft
12 Carrington Ct

Clifton Park, NY
Experience the ease of first-floor living in this beautifully maintained 3,000-square-foot Colonial, perfectly situated on 1.53 private acres in the award-winning Shenendehowa Central School District. Designed for both comfort and functionality, this home features a sought-after first-floor primary suite complete with a cozy gas fireplace, along with the convenience of first-floor

Melissa Hems Crystal Coleman Realty LLC

Co-Listing Agent

$199,900
- 6 Beds
- 2 Baths
- 2,742 Sq Ft
79 Central Terrace

Cohoes, NY
Two-Family Property., perfect for both the seasoned investor and those entering the market for the first time. Located in the high-demand rental markets of Cohoes This home offers a blend of stable tenancy, separate utilities, and strong, reliable cash flow. The property features: Two spacious rental units. Independent utilities for simplified management and reduced overhead. Established tenants

Melissa Hems Crystal Coleman Realty LLC

Co-Listing Agent

$289,900
- 4 Beds
- 2 Baths
- 1,176 Sq Ft
13 Batcher St

Albany, NY
Fantastic development opportunity! Package of 8 parcels! Offering a 2 family home with a 2 car detached garage, another 5 bay garage with 8 vacant land parcels. The first floor apartment is renovated in the two family but the 2nd floor needs rehab. Both units are occupied with longer term tenants. The first floor pays $750 and the second floor pays $650 and both are month to month. Enjoy plenty

Melissa Hems Crystal Coleman Realty LLC

$299,900

Pending
- 4 Beds
- 2 Baths
- 2,060 Sq Ft
603 1st St

Watervliet, NY
Beautifully updated duplex offering turnkey living & strong rental income. This all-new duplex features fresh interior paint & luxury vinyl flooring throughout, creating a modern, cohesive aesthetic across both units. First Floor (could rent for $1750-1800): vacant & ready for owner-occupancy. This spacious flat includes: 2 bedrooms, including a large primary bedroom with a walk in closet, office

Melissa Hems Crystal Coleman Realty LLC

$349,900

Pending
- 4 Beds
- 1.5 Baths
- 1,004 Sq Ft
19 Chinquapin Ave

East Greenbush, NY
FIRST Open House 7/19, 11-1PM. This bright and spacious approx. 1,700 square foot home offers a comfortable and well-designed layout featuring 3-4 bedrooms and 1.5 bathrooms, with the half bath conveniently incorporating the washer and dryer. The upper-level full bathroom offers a gorgeous vanity and shower tub unit. The main level offers attractive hardwood flooring throughout much of the space,

Melissa Hems Crystal Coleman Realty LLC

$299,900

Pending
- 9 Beds
- 3 Baths
- 2,970 Sq Ft
166 2nd St

Albany, NY
Fantastic 3 unit with gleaming hardwoods, hot air heat. Fully rented with separate utilities: Rents are $1,000, $1,250 and $1,350. Do not miss this opportunity to own this brick 3 unit where rents could be higher with fair market being $1700+ per month.

Melissa Hems Crystal Coleman Realty LLC

$2,150 per month
- 2 Beds
- 1.5 Baths
- 1,050 Sq Ft
3 Minnowbrook Ave

Unit A

Delmar, NY
Walk to the desirable Four Corners and get your delicious breakfast sandwich at McCarrols. This 1st floor unit offers 2 bedrooms, Sunroom, formal dining room, large living room, 1.5 baths, central air, hardwood floors, garage and laundry available in the building.

Melissa Hems Crystal Coleman Realty LLC

$1,600 per month
- 1 Bed
- 1 Bath
- 650 Sq Ft
324 Hudson Ave

Unit 1

Albany, NY
FIRST FLOOR! 1 bedroom 1 bath apartment in desirable Center Square. HEAT INCLUDED. Only this first-floor unit and basement walk-out unit have access to the backyard (7 unit building total) Short walk to Lark St, bus lines and Washington Park. Coin operated laundry units in private room in the basement. Hardwood floors, stained glass window, soaring ceilings, kitchen open to the living room with

Melissa Hems Crystal Coleman Realty LLC

Recently Sold

$300,000

Sold Jun 29, 2026
- 4 Beds
- 2 Baths
- 1,540 Sq Ft
200 New York 5s

Pattersonville, NY
- 3% Below List
- 9 Days On Market
- $195/SF
Melissa Hems Crystal Coleman Realty LLC

$415,000

Sold Jun 17, 2026
- 5 Beds
- 4 Baths
- 2,004 Sq Ft
111 Hollywood Ave

Albany, NY
- 4% Above List
- 4 Days On Market
- $207/SF
- Current Est. Value $405K
Melissa Hems Crystal Coleman Realty LLC

$739,000

Sold Jun 10, 2026
- 6 Beds
- 7 Baths
- 4,940 Sq Ft
324 Hudson Ave

Albany, NY
- 8% Below List
- 186 Days On Market
- $150/SF
Melissa Hems Crystal Coleman Realty LLC

$194,000

Sold May 8, 2026
- 4 Beds
- 2 Baths
- 2,244 Sq Ft
193 Livingston Ave

Albany, NY
- 3% Below List
- 9 Days On Market
- $86/SF
- Current Est. Value $197K
Melissa Hems Crystal Coleman Realty LLC

$330,000

Sold Mar 19, 2026
- 6 Beds
- 2 Baths
- 2,772 Sq Ft
112 Kenosha St

Albany, NY
- 10 Days On Market
- $119/SF
- Current Est. Value $333K
Melissa Hems Crystal Coleman Realty LLC

$420,000

Sold Mar 10, 2026
- 4 Beds
- 3 Baths
- 2,508 Sq Ft
208 Elm St

Albany, NY
- 8% Above List
- 1 Day On Market
- $167/SF
- Current Est. Value $416K
Melissa Hems Crystal Coleman Realty LLC

$319,900

Sold Oct 30, 2025
- 3 Beds
- 2 Baths
- 1,680 Sq Ft
1722 Randolph Rd

Schenectady, NY
- 9% Below List
- 30 Days On Market
- $190/SF
- Current Est. Value $329K
Melissa Hems Crystal Coleman Realty LLC

$449,900

Sold Oct 27, 2025
- 2 Beds
- 1 Bath
- 1,800 Sq Ft
5 Peel St

Selkirk, NY
- 0 Days On Market
- $250/SF
- Current Est. Value $471K
Melissa Hems Crystal Coleman Realty LLC

$148,000

Sold Jul 9, 2025
- 5 Beds
- 2 Baths
- 1,610 Sq Ft
182 Hill St

Troy, NY
- 12% Below List
- 26 Days On Market
- $92/SF
- Current Est. Value $154K
Melissa Hems Crystal Coleman Realty LLC

Other Experience

First Time Homebuyers, Investments, Military Families, Veteran's Programs, Senior Communities, Short Sales, Luxury Homes

Agent License: New York #10401215159

Melissa Hems

(518) 765-7059

Responds Quickly

(518) 765-7059

Homes for Sale by City

Melissa Hems

About Melissa

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 Melissa is Experienced In

Melissa's Listings and Deals

Melissa's Open Houses

Melissa's Recent Active Listings

Recently Sold

Other Experience