Refine Search
Sort by
$1,050,000
3 Beds 2 Baths 994226 MLS
Welcome to this well-maintained brick two-family home located on a quiet block in the heart of Sheepshead Bay. The upper level features a spacious 2-bedroom layout with a bright living room, eat-in kitchen, front porch, and rear deck—perfect for relaxing. The walk-in level has been recently updated and offers a comfortable living room, kitchen, full bathroom, and formal dining area that can easily be converted into a second bedroom. This level also provides direct access to the private backyard. Additional features include a built-in one-car garage, carport, and major updates with the roof, boiler, and deck all replaced only a few years ago. A great opportunity for end-users or buyers seeking flexible living space in a prime Brooklyn location. Please note: Some photos have been virtually cleaned and enhanced for presentation purposes.

2544 Hubbard Street, Brooklyn

$975,000
4 Beds 2 Baths 987167 MLS
114 Tallman Street | Southeast Annadale Charming High Ranch • Move-In Ready • Exceptional Layout Dead-End Street • Park-Like Green Setting • Direct Trail Access to Park. Welcome to this beautifully maintained one-family High Ranch, perfectly situated on a quiet dead-end street surrounded by lush greenery, offering a rare sense of privacy and tranquility — with a direct trail leading to the park. From the moment you enter, you're greeted by a grand foyer that sets the tone for this warm, inviting, and thoughtfully designed home. Built for both comfortable living and effortless entertaining, this residence features a seamless layout, generous room sizes, and abundant natural light throughout. Home Features• 4 Spacious Bedrooms• 2 Full Bathrooms• Private Garage + Paved walkway• Fully Finished Basement• Fenced-In Yard with Deck and brick patio. First Level • Impressive grand foyer with double coat closets• Cozy family room with wood-burning fireplace• Anderson sliding doors leading to a private fenced-in yard and brick patio• Versatile 4th bedroom (ideal for guest room or home office) • New Full bathroom + laundry room• Direct access to garage. Main Level• Sun-filled formal living room with vaulted ceilings• Elegant skylight above staircase• Formal dining room• New Eat-in kitchen with new stainless-steel appliances• Primary bedroom with two walk-in closets• Two additional bedrooms + full bathroom and towel warmer. Upgrades & Highlights• 4-Zone heating system (updated approx. 5 years ago) • 2 Water heaters (40-gallon + tankless) • A/C system• Roof approx. 10 years old• Custom European doors throughout. Hardwood floors throughout. Outdoor Living. Enjoy your own private outdoor retreat, featuring: • Fenced-in backyard with deck and patio for great entertaining. • Sprinkler system• Beautiful, park-like surroundings. Why You'll Love It. A rare opportunity to own a home that combines space, comfort, and location —

114 Tallman Street, Staten Island

$1,250,000
4 Beds 3 Baths 986850 MLS
Two family residence in need of updating, offering a strong value-add opportunity for qualified builders and developers to reposition or redevelop a property to its highest and best use. Situated on a 48' x 100' lot, the property includes a detached two car garage, an increasingly rare and valuable feature in the area. The home is underbuilt relative to current allowable residential FAR under R4A zoning, presenting meaningful potential for expansion or redevelopment. There may be opportunities to explore reconfiguration, enlargement, or the addition of an internal or external Accessory Dwelling Unit (ADU) subject to buyer due diligence and all required approvals. Located on a quiet residential block, the property is close to local shopping, schools, parks, and transportation, supporting long term resale or rental demand once improved. The home is currently tenant occupied but expected to be delivered vacant, allowing buyers to proceed with renovation or construction plans following closing, subject to confirmation. An excellent opportunity for builders or developers seeking a true value add project in an established neighborhood, with the ability to redesign layouts, modernize systems, and potentially enhance upon completion, subject to renovation scope and approvals. All information is deemed reliable but not guaranteed. Prospective purchasers must perform their own due diligence and independently verify all information. Bring your architect, contractor, and vision—projects with this lot size, zoning profile, and upside are increasingly difficult to find.

23-40 124th Street, College Point

$1,499,000
3 Beds 3 Baths 986832 MLS
A rare opportunity in one of Staten Island's most sought-after hilltop locations. 18 Emerson Avenue (100Ã--105 lot) offers breathtaking water views along with exceptional potential for the right buyer. The existing ranch home presents the opportunity to renovate or customize to your vision, with fully approved architectural plans already in place--allowing for a seamless path to build a custom luxury residence. Exceptional Add On: the option to purchase as a package with 119 Coverly Avenue (95Ã--100 lot), creating a rare street-to-street 100Ã--200 property with water views--an opportunity that is truly one of a kind. Whether renovating or building new, this is your chance to create a custom home on one of Staten Island's premier hills. The existing ranch offers spacious interiors, a bright layout, wood-burning fireplace, and finished basement, all set on a quiet block. Ideally positioned for a seamless commute to the city while maintaining a private, suburban feel with a sense of luxury. Approved plans allow for the development of a substantial single-family residence, offering a rare opportunity to bypass the approval process and move directly into construction. Surrounded by high-end homes, this location supports long-term value and the creation of a truly standout property. Prime location, expansive property, and unmatched potential--bring your vision to life.

18 Emerson Avenue, Staten Island

$2,700,000
3 Beds 3 Baths 986752 MLS
Package deal available — a rare opportunity in one of Staten Island's most sought-after hilltop locations. 18 Emerson Avenue (100×105) offers breathtaking water views and exceptional potential for the right buyer. The existing ranch home presents the opportunity to renovate or build to your vision, with fully approved architectural plans already in place—allowing for a seamless path to a custom luxury residence. Exceptional Extra: the option to purchase in conjunction with 119 Coverly Avenue, creating a rare 100×200 street-to-street property with panoramic water and bridge views—an offering that is truly one of a kind. Whether renovating or building new, this is your chance to create a signature home in one of Staten Island's premier hilltop enclaves. The existing ranch features a spacious layout, sunlit interiors, wood-burning fireplace, and a finished basement, all set on a quiet, private block. 119 Coverly Avenue is a separately approved elevated parcel offering unobstructed views of the Verrazzano-Narrows Bridge and New York Harbor. Positioned just off Ocean Terrace, this 9,500 sq. ft. lot sits within the NA-1 Natural Area District, providing a serene, tree-lined setting with sweeping skyline vistas—ideal for a modern architectural build designed to maximize its elevation and surroundings. Surrounded by multi-million-dollar homes and ideally located near Staten Island Academy, Clove Lakes Park, and the Staten Island Expressway, this offering combines privacy, prestige, and convenience. Approved plans, expansive property, and unmatched views—whether purchased individually or as a package, this is a premier opportunity to build a standout luxury residence in one of Staten Island's most desirable locations.

18 Emerson Avenue Unit #P, Staten Island

$999,999
7 Beds 4 Baths 971275 MLS
120-30 226th Street – A Truly Exceptional Single-Family Residence Welcome to 120-30 226th Street, one of the largest single-family homes in the entire area—a rare opportunity that stands far above the typical properties nearby. Measuring 25 feet wide by 38 feet deep and fully built out across all three levels, this home delivers an incredible amount of living space and flexibility. The first floor offers a thoughtfully designed layout ideal for both everyday living and entertaining. A sprawling living room welcomes you as you enter, leading to a formal dining room in the rear of the home. The full kitchen sits privately on the opposite side, creating a comfortable and functional cooking space . This level also includes a convenient bedroom and full bathroom, along with a dedicated laundry station, eliminating the need to carry laundry up and down stairs. The second floor features an impressive primary suite larger than many homes in the area, complete with a walk-in closet and private en-suite full bathroom. Two additional king-sized bedrooms complete this level, offering generous space rarely found in comparable properties. The fully finished basement adds tremendous versatility with an accessory unit featuring three bedrooms, a kitchen, and a separate entrance, making it ideal for extended living arrangements or additional space for guests. Situated on a 40 × 100 lot, the property also features a fully concreted backyard and a detached garage, providing low-maintenance outdoor space and convenient parking. Adding to its uniqueness, the home is located just steps from the Ohel, allowing you to be there in moments—simply roll out of bed and walk straight over. This is truly a one-of-a-kind home offering unmatched size, layout, and location. A property like this rarely becomes available. Must see to appreciate.

120-30 226th Street, Cambria Heights

$1,549,900
2 Beds 3 Baths 957178 MLS
Well-maintained mixed-use property in the heart of Astoria featuring a medical office on the first floor and two residential units above. The ground-floor professional space is currently configured as a fully furnished doctor’s suite, offering a functional layout ideal for medical, dental, therapy, or other professional use. The residential portion consists of two separate one bedroom apartments, each with generous layouts, balconies, ample natural light, and well-proportioned rooms. Perfect for owner-users, investors, or professionals seeking to combine business and residential living in one of Queens’ most desirable neighborhoods. Conveniently located near major thoroughfares, public transportation, shopping, dining, and Astoria’s vibrant commercial corridors. This property offers strong income potential, flexible use, and long-term value in a high-demand area.

3014 31st Avenue, Astoria

$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.