Completely updated, this one-of-a-kind home is where exceptional design meets incredible versatility. Thoughtfully designed by Georgie Award-winning Intermind Design, this residence showcases top-of-the-line custom finishes throughout , galley style kitchen perfect for entertaining, open concept living and dining, complemented by a stunning sunroom that adds even more space and natural light. Enjoy a spacious deck with a remote-controlled roof and an entertainment-sized private backyard featuring a gazebo beside a patio area. Ample parking includes three garages. What truly sets this property apart is its flexibility for extended family or rental income, if desired. A rare opportunity to own a truly turnkey home where no detail has been overlooked. A must see
Two-car garage with overhead doors, upper-level balcony with metal railing, and mature hedge landscaping
Exterior featuring a grey siding facade, a red front door, and a second-level balcony with black railings
Third garage and coach home
Expansive backyard with a manicured lawn, established trees, and a privacy fence
Concrete patio featuring a wood-frame gazebo and surrounding landscaping
Expansive outdoor deck featuring a contemporary pergola, integrated string lighting, a gas fire pit, and durable railing
Recessed lighting illuminates wood-finish flooring, a textured stone-finish fireplace wall, and a built-in linear fireplace
Wood-finish flooring, recessed lighting, built-in display cabinetry, stone-clad fireplace with integrated hearth, and a large bay window
Hexagonal tile accent wall with a linear fireplace, recessed lighting, and wood-finish flooring
Open-concept living area with wood-finish flooring, two crystal chandeliers, and a kitchen featuring stainless steel appliances, an island with pendant lighting, and dark wood-finish cabinetry
Wood-finish flooring throughout, with a crystal chandelier illuminating the dining area
Built-in bar with wood-finish lower cabinetry, light-toned upper cabinetry, stone countertop, and an integrated beverage refrigerator
Modern kitchen featuring light wood-finish flooring, recessed lighting, and stylish pendant lights
Sunroom with black-framed windows, paneled ceiling, wood-finish flooring, and a decorative ceiling light
Enclosed patio featuring light wood-finish flooring, white paneled walls, and a recessed ceiling with a woven light fixture
Foyer featuring paneled wall covering, white staircase with runner, white tile flooring, and a second-story balcony
White tiled flooring, white painted staircase with dark treads, dual entry doors with stained glass, decorative wall paneling, and a chandelier light fixture
Wood-finish flooring throughout, white trim, and recessed lighting
Hardwood-finish flooring, crown molding, and a contemporary chandelier
Hardwood-style flooring throughout
Bathroom featuring a wood-finish vanity with a white countertop, an integrated sink with a chrome faucet, and a medicine cabinet with integrated lighting
Kitchen featuring tile flooring, wood cabinetry, and a tile backsplash
Wall-mounted vanity with a stone countertop and an undermount sink
Laundry area featuring white cabinetry, a utility sink, and white large-format tile flooring
Recessed ceiling lighting illuminates this versatile living space featuring wall-mounted shelving and a dedicated media wall with an electric fireplace
Recessed lighting illuminates a spacious room featuring a built-in electric fireplace and a media console
Attached garage with a white sectional door and an automatic opener
Wood-finish flooring, white paneled doors, intricate patterned wall covering, wood beam accent, and a skylight
Expansive room featuring rich wood-finish flooring and multiple windows
Exterior balcony with black railing
Double vanity with vessel sinks, glass-enclosed shower, skylight, and mosaic tile flooring
Wood-finish flooring with white walls and a window featuring blinds
Wood-finish flooring with a flush-mount ceiling light fixture
Light wood-finish flooring with white walls and a ceiling-mounted lighting strip
Dual vanity sinks with white cabinetry and integrated storage
Freestanding soaking tub with floor-mounted faucet, glass-enclosed shower with tiled surround, white vanity with integrated sink, and light-toned tile flooring
Integrated laundry appliances with a stacked washer and dryer
Attic space featuring wood-finish flooring, an arched window, a pendant light fixture, and a built-in desk area
Attic space featuring sloped ceilings, wood-finish flooring, recessed window, and pendant lighting
Data was last updated September 9, 2026 at 05:40 PM (UTC)
Area Statistics
Listings on market:
111
Avg list price:
$908,000
Min list price:
$399,000
Max list price:
$2,388,000
Avg days on market:
64
Min days on market:
1
Max days on market:
604
Avg price per sq.ft.:
$620.99
These statistics are generated based on the current listing's property type
and located in
Queensborough. Average values are
derived using median calculations. This data is not produced by
the MLS® system.