Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1862 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1862 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1862 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3 Sparrow Ridge Road
Carmel, NY 10512
Perry Tevere with BHG Real Estate Choice Realty, original listing - (914) 725-4020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1585 Square Feet
Agency: BHG Real Estate Choice Realty
Agency Phone: (914) 725-4020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Townhouse
Year Built: 1998
Notes: Welcome home to this beautiful townhome in Sparrow Ridge with a full Basement! This amazing townhome boasts 2 bedrooms plus bonus room/den/office, 2.5 bathrooms, and 1,585 sqft on the first 2 floors. The fully finished basement adds another 800 square feet making this unit a total of 2,385 square feet total. The townhouse has a brand new roof, new windows and storm door, newer Hot Water Heater, and much more. Enter through the front door which has a generous size porch perfect for morning coffee or an evening glass of wine. The first floor features an expansive living room with a wood burning fire place, cathedral ceiling and opens to the dining room. The Eat-in-kitchen has two entrance, granite counters, stainless steel appliances and wood cabinets., there is even a pass thru to the formal dining room with sliding doors out to the newly refinished deck. The den/office is also on the 1st floor along with a half bath and door out to the pristine 1 car garage. Upstairs features 2 large bedrooms each with their own en-suite bathrooms and laundry/linen closets. The primary bedroom has a large walk in closet with access to attic storage above the unit. A fully finished basement is a major feature as not all units have this. The opportunities are endless with a space of this size. The HVAC and 4 year old Hot Water Heater are located in a closet in the basement. Parking for 1 car in the attached garage plus another in the driveway. Visitor parking is very close as well. Taxes do not include the STAR discount. Recording devise on the property is in use.
MlsNumber: --
ListingId: 857440


Listing Provided By: BHG Real Estate Choice Realty, original listing
Phone: (914) 725-4020
Office Phone: (914) 725-4020
Agent Name: Perry Tevere
Disclaimer: Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App