Sharon FronkRealtor® · Howard Hanna
LoadingActive
New Listing
$225,000
11Q S Overlook Lane
Warrensburg, NY 12817 · Warren County
3Beds
2.5Baths
1,200Sq Ft
0.01 acresLot Size
1940Year Built
$188Per Sq Ft
Est. P&I $1,138/moGet pre-qualified
Condo $532/Monthly HOA New today
MLS# 202625548 Updated 7h ago
Sharon’s Take
This three-bedroom, two-and-a-half-bath condo in Warrensburg sits within Green Mansions, a private community offering deeded access to Tripp Lake and membership in its Tennis and Swim Club. The 1,376-square-foot unit spans three floors and includes a full basement, fireplace, eat-in kitchen, and in-unit laundry. The HOA covers heat, lawn maintenance, snow removal, trash collection, and access to kayaks, canoes, community boats, and recreational facilities including tennis, pickleball, and other courts. Located in the North Warren Central school district with seasonal waterfront access, the property is listed mostly furnished.
Sharon Fronk · Howard Hanna Capital Region
About this property
Escape to your Adirondack dream in this beautiful condo nestled within the private Green Mansions community. This affordable Adirondack retreat offers the perfect balance of rustic character and low-maintenance living, ideal as a cozy getaway or full-time residence. The condo features three floors of living space and an in-unit washer and dryer. Relax on the front deck while enjoying filtered views of Tripp Lake. The property is being sold mostly furnished, so you can move in and start enjoying the Adirondacks right away. Dogs are welcome, too! Located just moments from Tripp Lake, residents enjoy exclusive lake and beach access. As part of the HOA, you'll appreciate truly low-maintenance living, with heat, lawn care, trash removal, snow clearing--including pathways and decks--and more all taken care of. Plus, your membership in the Tennis & Swim Club includes access to kayaks, canoes, and community boats, along with tennis and pickleball courts, basketball, volleyball, bocce ball, and horseshoes. Conveniently located near everything the Adirondack Park has to offer, yet tucked away enough to feel worlds apart.
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Warrensburg sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$188
Days on market
New today
Fresh listing
Year built
1940
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
36 facts pulled straight from the MLS listing.
Overview
Property TypeCondo
Sub-TypeCondominium
Year Built1940
StatusActive
MLS Number202625548
ListedSeptember 6, 2026
SubdivisionGreen Mansions
Interior
Bedrooms3
Bathrooms2 full, 1 half
Living Area1,200 sq ft
Fireplaces1
Heating
BaseboardOil
Cooling
Window Unit(s)
Flooring
TileCarpetLaminate
Basement
FullSlab
Interior Features
Full BasementEat-in KitchenWood Burning
Exterior & Lot
Lot Size0.01 acres
Parking
Paved
Exterior Features
Drive-PavedTennis Court(s)WaterfrontSeasonal AccessSharedDeeded Water AccessWaterPaved
Building & Construction
Architectural Style
Condominium Unit
Construction
Wood Siding
Roof
Asphalt
Sewer
Shared Septic
Water Source
Shared Well
Utilities
Cable Connected
Financial
List Price$225,000
Price per Sq Ft$188
Special Conditions
Standard
HOA$532 / monthly
HOA Includes
Heating
Est. Monthly P&I$1,138/mo
Location
CountyWarren
School DistrictNorth Warren
Listing Details
Listed ByTammy J Sutphin of Hunt ERA
Data SourceSpark Platform / Global MLS
Last UpdatedSep 6, 2026
What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start11Q S Overlook Lane, Warrensburg, NY 12817
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
North Warren
Assigned school district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Warrensburg, NY
Warrensburg is in Warren County, NY. There are currently 35 active listings here, ranging from $47,000 to $699,000. Listings in this address fall under the North Warren school district. Priced 18% below the Warrensburg median of $274,900.
See Sharon's Warrensburg community guideYou might also like
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Hunt ERA · Listed by Tammy J Sutphin (war.sutpta)
Contact: 518-796-2211
MLS #202625548 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
