Refine Search
Sort by
$1,650,000
4 Beds 3 Baths 969876 MLS
Spacious 4-bedroom, 3-bathroom home located in the desirable neighborhood of Holliswood. Situated on a large corner lot, this property offers exceptional space both inside and out. The home features solar panels, helping to reduce energy costs and improve efficiency. The main level offers a comfortable layout with generous living space, while the fully finished basement includes 3 additional bedrooms, a full bathroom, living room, and kitchen, providing excellent potential for extended family or flexible living arrangements. With its expansive lot, prime corner location, and versatile layout, this property offers incredible opportunity for homeowners seeking space, convenience, and long-term value in one of Queens’ most sought-after residential communities. *This property is sold in as-is condition*

86-34 Francis Lewis Boulevard, Holliswood

$75,000,000
8 Beds 14 Baths 959838 MLS
An extraordinary 268-acre legacy estate spanning the New York-Connecticut border, Hillandale offers unrivaled privacy and timeless grandeur. Once owned by the Sulzberger family of the New York Times, the 15,000+ sq ft, eight-bedroom European-inspired manor has been meticulously restored and features magnificent formal entertaining rooms, 11 fireplaces, two elevators, a paneled library, sun-filled conservatory, billiard room, sauna, gym and an Olympic-sized indoor pool with spa. There is also an outdoor pool with dedicated pool house. Vast, beautifully designed grounds showcase formal gardens, a private lake, woodland trails, a hedge maze and lighted tennis court. Four separate guest houses and a separate garage apartment on the property create a truly unparalleled private compound. This is a once in a generation offering for those seeking exceptional elegance and seclusion. Total Acreage 268+ acres: 173+ in Pound Ridge, New York, 95+ in Stamford, Connecticut

Stamford

$848,000
5 Beds 2 Baths 955455 MLS
Move right into this fully gut renovated single family home offering approximately 1,880 square feet of living space with 5 bedrooms, 2 full bathrooms, and a semi finished basement with a separate entrance and excellent potential. The property sits on a rare double lot measuring roughly 60x90, totaling about 5,400 square feet, and includes a 2 car garage plus a private driveway for ample parking and outdoor flexibility. Major upgrades include 100% new plumbing, new electrical, new roof, new siding, new boiler, and a new hot water tank, delivering true turnkey condition and long term reliability. The first floor features 2 bedrooms, a kitchen, dining room, living room, and a full bathroom, while the second floor offers 3 bedrooms and a full bathroom. Conveniently located near Q5, Q85, Q86, Q89, Q113, and Q114 bus lines, with nearby LIRR stations at Laurelton, Rosedale, and Valley Stream for easy access to Jamaica, Midtown Manhattan, and Long Island.

136-11 Brookville Boulevard, Rosedale

$1,128,000
3 Beds 2 Baths 940781 MLS
Middle Village N: Welcome to this lovingly maintained and updated semi-detached brick 1-family home, nestled in the highly desirable Middle Village neighborhood. Boasting both beautiful original details and modern upgrades throughout, this property embodies classic Middle Village charm. As you enter the property via the entrance vestibule, you’re greeted with an open-floor plan and heated floors throughout, including a bright and spacious living room with a gas fireplace, dining room, and modern kitchen with stainless steel appliances. The second story features 3 bedrooms and a full modern bathroom with heated floors and heated towel racks. The full-finished basement of this property provides ample space for an office, play area, or for entertainment, has its own split system, laundry room, and also contains a convenient full modern bathroom as well. Additional features include stunning oak floors throughout, new tankless heat and hot water heater, split system & central AC units, and easy parking in your own 1-car garage and driveway. The rear private fenced-in yard provides a quaint seating area providing peace and tranquility, a true escape from the everyday hustle and bustle of Queens living. Conveniently located near the extremely popular scenic Juniper Valley Park, providing 55-acres of lush greenery and space for outdoor recreation, and is zoned for the top-rated PS/IS 49 school and Forest Hills High School. This home provides easy access to a wide range of shopping, dining, and houses of worship. Commuters will appreciate easy access to public transit, including local Q14, Q29, Q38, and Q47 bus lines, as well as express routes QM24, QM25, and QM34 to Manhattan. This property provides the peacefulness of a residential area while still having easy access to the amenities and entertainment options of the city.

64-68 83 Place, Middle Village

$6,695,000
7 Beds 7 Baths 918309 MLS
A rare opportunity to own one of Litchfield County's most exceptional legacy estates. Reverie Farm encompasses more than 101 acres across four separate parcels, offering extraordinary privacy, sweeping views, and endless possibilities as a country retreat or full-time family compound. The meticulously restored and updated 1799 stone and shingle residence, which features 7 bedrooms, 5 full and 2 half baths, intimate entertaining spaces, multiple fireplaces, and a 1-bedroom in-law apartment with both interior and private exterior access, is rich in historic character. Additional accommodations include a separate 3-bedroom, 2 bath guest house with its own driveway, and a separate 2–bedroom staff/guest apartment. Estate amenities include a heated gunite pool in a private garden space, tennis court, the renowned studio of Abstract Expressionist Cleve Gray and, across the driveway, his wife author Francine du Plessix's writing studio which has been transformed into a dance studio/entertaining space with a double height ceiling. Additional outbuildings offer exceptional flexibility for use as gathering spaces, remote workspaces, athletic facilities, studios, workshops, storage (wine, automobiles, and other collectibles), and other uses subject to local approvals. The open fields, woodland trails, ancient fruit trees, established gardens and stone walls create an extraordinary private setting with agricultural and equestrian potential. Several of the estate's four parcels offer additional residential building sites, presenting a rare opportunity to expand thoughtfully while still preserving the extraordinary privacy that defines the property today. Permitted access to Lake Waramaug for swimming and boating is available through the town of Warren. The Mayflower Inn, the villages of Washington, New Preston, and Kent, and many of New England's most celebrated independent schools are all close at hand. Reverie Farm is a truly unique Connecticut estate where history, artistry, recreation, and multigenerational living come together on one remarkable property that is magical in every season.

102 Melius Road, Call Listing Agent

$2,250,000
10 Beds 6 Baths 850195 MLS
Experience quiet country living with this beautiful mixed-use farm & investment property! This unique property has so much to offer, including FOUR rental units (3 single family homes + a 3-bedroom apartment), a scenic creek that runs along the entire edge of the property (perfect for summer swims!) , stunning woodland trails with views of the mountains and farmland, along with multiple large barns & fertile soils, ideal for farming & agriculture. ---- The 2,157 sq. ft. historic stone house, built in 1780, has 2 bedrooms, 1.5 baths, hardwood floors, a large parlor, a dining room and living room, a porch overlooking the pond & a separate large carriage house 2 storage bays, a garage space, & a second floor that can be converted into additional storage or living space. This home has been recently updated & freshly painted & has a new roof & new septic system. ---On this property you will also find a large private pond (perfect for fishing!), tons of storage areas, and a 3-bay workshop (perfect for wood-working or other hands-on projects), several large barns capable of storing farm equipment, hay, boats, animals, lumber, vehicles, etc., and wooded areas for hiking & other ideal spots for hunting or camping. ---In addition to the stone house, this property also has 3 ADDITIONAL units. It also has a well and septic already set up for a potential 5th unit near the pond, making this an incredible investment opportunity! The fields can also be leased out to farmers for additional income & tax exemptions. ---The 3 additional units include: --"The Log House" which is a 1,068 sq. ft. single-family log home built in 2006, with 2 bedrooms (plus 2 garrett rooms on second floor), 1 bathroom, a full basement and a large wrap-around porch. --"The Ranch" which is a 1,425 sq. ft. ranch-style modular home with 3 beds and 2 baths, a large full walk-out basement, a beautiful spacious yard with a large pond, and a storage shed. There is also a small creek that runs along the back of the home, a large wrap-around porch, and a ton of privacy! -- *This unit is located on the opposite side of the road, along with the existing well & septic for potential 5th unit - this portion of the property would be easily subdividable.* ---"The Milkhouse Apartment" is a roughly 965 sq. ft. 3 bed, 1 bath apartment located on a second floor above the milkhouse. It has a spacious living room with a sliding door to the rear deck which allows for privacy and views of the back fields & the creek, and it also has a large storage unit underneath. ---The property also has 2 chicken coops if you are looking to raise your own chickens! There are also multiple large barns capable of housing many other animals, making this an ideal place for an animal sanctuary. ---This property offers both convenience & peace and quiet. It is located on a quiet back road, but less than 10 minutes from downtown Hudson, grocery stores, schools, hospital, restaurants, clothing stores, and the train station. The large open fields offer wide views of the night sky, perfect for star-gazing! Come see it for yourself, the possibilities are endless! --(Located in the town of Greenport [no zoning]) (Associated with MLS#850930 (land))

274 Fingar Road, Hudson

board logo

© 2026 TReND. All Rights Reserved.
The data relating to real estate for sale on this website appears in part through the TReND Internet Data Exchange (IDX) program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Real Broker NY LLC participates, and is provided by TReND through a licensing agreement. Real estate listings held by brokerage firms other than Real Broker NY LLC are marked with the IDX icon and detailed information about each listing includes the name of the listing broker.
All information provided is deemed reliable but is not guaranteed. Some properties which appear for sale on this website may no longer be available because they are under contract, have sold or are no longer being offered for sale. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.