Contact Agent Homes with Public Water

Welcome to your future home in the heart of New York, where comfort meets convenience! Nestled in a vibrant community, this area boasts a top-rated school district known for its commitment to academic excellence and holistic development. Families in this district enjoy access to a range of educational programs, dedicated teachers, and a nurturing environment that encourages students to thrive. Whether you're looking for elementary, middle, or high school options, you can rest assured that your children will receive a quality education that prepares them for future success.

The homes in this charming neighborhood come with the added benefit of public water, ensuring a reliable and convenient water supply for all your household needs. Imagine the peace of mind that comes with knowing your home is equipped with this essential service, allowing you to focus on what truly matters—creating lasting memories with your loved ones.

As you explore the available homes in this delightful region, you'll find properties that cater to every lifestyle, from cozy bungalows to spacious family residences. Each home is designed to provide comfort and warmth, making it the perfect backdrop for your life’s most cherished moments.

For more information about these wonderful homes and the outstanding school district, please don’t hesitate to contact our dedicated real estate agent. We’re here to help you find the perfect place to call home in this thriving New York community! Let us assist you in making your dream of homeownership a reality.

Newest Contact Agent Homes with Public Water

$438,000

1 Beds ⋅ 2 Baths ⋅ 1032676 MLS

Welcome to collaborate and share! Unlisted co-op just 3 minutes from Elmhurst subway station, the building was completely renovated last year, and most importantly, three new elevators were installed, making it arguably the most beautiful co-op ever! Beautiful garden community! Management fee is only around $1000, A spacious 900+ sq ft one-bedroom apartment, usable as a two-bedroom, all interiors freshly painted, windows newly replaced, all utilities included except electricity

8710 51st Avenue Unit #3H, Elmhurst

$1,150,000

1032679 MLS

Looking to build your portfolio? Add this trophy property to your collection! 188 Lenox is a rare architectural canvas located on historic Lenox Avenue. Built in 1887, this turn-of-the-century, mixed-use townhouse is situated along one of Upper Manhattan’s most iconic corridors and is available for sale. 188 Lenox Avenue is a 4-unit, mixed-use building located between 119th and 120th Streets. This property features ground-floor commercial space—currently being used as a hardware store—and three vacant residential units above. The property can be restored to its original beauty to generate passive rental income, or it can be renovated and converted into condos. For comparison, condos at 192 Lenox (just two buildings down) have sold in the $700K to $1M range. The building can be delivered with a Certificate of Non-Harassment and DOB-approved plans to convert into a legal 4-family building plus commercial space. Approved Plans Include: * 2nd Floor: Two (2) studio apartments, projected to rent for a minimum of $2,646/month each. * 3rd & 4th Floors: Two (2) floor-through 2-bedroom apartments, projected to rent for a minimum of $3,058/month each. * 1st Floor: Commercial space with excellent retail frontage near the Mount Morris Park Historic District. Can be rented for approximately $90/sq. ft., bringing in roughly $10,500/month. Unleash immediate upside in Harlem’s historic and commercial heart! Grand Totals * Total Monthly Income (4 Residential + 1 Commercial):?$11,408+$10,500=$21,908 / month? * Total Annual Gross Income:?$21,908×12=$262,896 / year? At a fair aqcuisition price, with conservative expense estimates, this property can bring in a double-digit cap rate (11.5% to 13.1%) which is an extraordinary return. Schedule your showing today!

188 Lenox Avenue, New York (Manhattan)

$2,700,000

1029012 MLS

1439 43rd Street, Brooklyn

$1,299,000

3 Beds ⋅ 2 Baths ⋅ 1028898 MLS

Welcome to 345 54th Street, a 3-bedroom, 2-bathroom duplex in the desirable Sunset Park section of Brooklyn! Located mid-block on a quiet, tree-lined residential street between 3rd and 4th Avenues, this property has legal air rights with INCREDIBLE potential to build up and expand. The partially finished basement provides additional storage space. Outside, enjoy your own private retreat from the city with a rear uncovered paved patio and deck. Don't miss out on this incredible multi-family opportunity in vibrant southwest Brooklyn for investment income or to customize your dream home! No interior access, tenant occupied, drive-by only.

345 54th Street, Brooklyn

$590,000

1031950 MLS

Welcome to The Virginia Queen Inn, an 1860 Italianate set directly on the village green in Jefferson, within the town's recently designated National Register Historic District. The two-story, four-bay wood-frame house spans roughly 2,756 square feet across a cross-gabled main block and rear wing, trimmed in deep Italianate friezes, paired scrolled brackets, and modillion blocks. Behind that facade sit nine guest suites and eight and a half baths, recently renovated. With a current legal non-conforming Operating Permit as a boutique hotel, with no short-term rental restrictions. A separate street-level commercial storefront adds a second use to this rare offering on one of the Catskills' beautifully preserved historic villages. Inside, wide-plank hardwood floors run beneath arched doorways, high ceilings, original pocket doors, and a turned-baluster staircase rises from an entry hall lit by a diamond-paned pendant fixture. The facade's Italianate entrance retains its paired doors with glazed upper panels, opening onto a foyer that sets the tone for a house built on careful, tactile detail. Two guest suites are arranged across the first floor, with the remaining seven bedrooms located on the second floor, most with private or ensuite baths. The second-floor signature suite opens onto a private balcony overlooking the green, and several suites can combine or share adjoining baths, giving a new owner flexibility for a full house of overnight guests, a large gathering, or a quieter stay. Outside, the one-story wrap-around porch spanning the facade and east elevation retains its original squared posts and corner braces with punchwork detailing; the east elevation section was enclosed in glass around 1920 and today serves as a sun porch overlooking the green. A separate street-level commercial storefront, with its own private entrance onto the green, is ready for a café, bakery, gift shop, or gallery, giving a new owner the option to run a business alongside the residence, or lease the space independently. The Virginia Queen Inn occupies one of Jefferson's most visible corners, neighboring the historic Maple Museum and the new Middlebrook Café & Bakery. The current owners have invested in the systems that support the house today: a new Navien propane hot water system, a Generac generator, updated plumbing, dedicated main-floor laundry with half bath, and a newer metal roof over a dry, well-kept attic. Jefferson itself is one of the region's least-altered nineteenth-century villages. From the porch, it's a short walk to the Jefferson General Store, the Mill Pond Inn & Restaurant, and Heartbreak Hotel. Stamford is six miles away, Cooperstown twenty-four, and Albany forty-five, with Amtrak service from Albany-Rensselaer and ski country at Hunter, Windham, Belleayre, and Plattekill all within reach. Offered fully furnished, The Virginia Queen Inn is ideal for a buyer drawn to hospitality, large-scale entertaining, or simply stewarding one of Jefferson's most storied addresses.

138 Main Street, Jefferson

$749,999

5 Beds ⋅ 3 Baths ⋅ 1032510 MLS

Welcome to 4059 Paulding Avenue, a beautifully renovated home where the quality of the renovations rivals new construction. This move-in-ready residence offers 5 bedrooms, 2.5 bathrooms, and a versatile layout perfect for today's living. The main living area features a spacious 3-bedroom duplex with bright, open living spaces, modern finishes, and thoughtful updates throughout. The walkout lower level features 2 additional bedrooms, a full bathroom, and a separate entrance, offering exceptional flexibility for extended living, guest accommodations, or potential rental income. Step outside to a beautifully finished backyard with elegant pavers, creating the perfect setting for outdoor entertaining, family gatherings, or simply relaxing in your own private oasis. As an added bonus, the seller is willing to contribute toward buying down the buyer's interest rate, helping to make homeownership even more affordable. Don't miss the opportunity to own this stunning, turnkey Bronx home that combines modern style, flexible living space, and exceptional value.

4059 Paulding Avenue, Bronx

$654,900

4 Beds ⋅ 3 Baths ⋅ 1032518 MLS

PROPERTY IS BEING LISTED SIGHT UNSEEN- (LSU) NO SHOWINGS ALLOWED AND NO INTERIOR ACCESS

60 Valleywood Road, Commack

$799,999

4 Beds ⋅ 3 Baths ⋅ 1032496 MLS

Welcome to 150-38 Grand Central Parkway, Briarwood—a beautifully maintained 4-bedroom, 3-bathroom home offering the perfect blend of space, comfort, and convenience in one of Queens’ most desirable neighborhoods. Ideally situated in the heart of Briarwood, this home provides exceptional access to major highways, public transportation, shopping, restaurants, parks, schools, and everything Queens has to offer, making commuting to Manhattan and surrounding areas effortless. Inside, you’ll find a bright and inviting layout with four generously sized bedrooms and three full bathrooms, providing ample room for comfortable everyday living. The home has been thoughtfully updated within the last 5 years, allowing the next owner to move right in with confidence. The fully finished basement, complete with its own separate entrance, offers outstanding flexibility—perfect for extended living, a recreation room, home office, gym, or additional entertaining space. Step outside to enjoy your own private backyard, an ideal setting for summer barbecues, outdoor dining, gardening, or simply relaxing in your own peaceful retreat. Whether you’re looking for more space, a home with versatile living options, or an unbeatable Queens location, this immaculate home presents an exceptional opportunity you won’t want to miss!

15038 Grand Central Parkway, Jamaica

$479,000

3 Beds ⋅ 2 Baths ⋅ 1032506 MLS

Welcome to 170 Kearsing Parkway, Apartment A. This beautifully renovated two-level home offers three spacious bedrooms, elegantly tiled bathrooms, and a brand-new kitchen with stunning granite countertops. You'll enjoy the convenience of an in-unit washer and dryer, making laundry a breeze. This is a perfect blend of modern updates and comfortable living. Simply a place to call home!

170 Kearsing Parkway Unit #A, Monsey

$1,428,666

7 Beds ⋅ 3 Baths ⋅ 1032351 MLS

Located in the convenient, desirable community of Pelham Bay is 1616 Pilgrim Avenue! This legal 3-family is a large, fully detached brick home being sold with tenants. One 2-bedroom turnkey unit is ready for you! This property has a total of 3450 square feet of livable space perfect for new owners or for investors to generate some extra income, with 4 separate electric and gas meters allowing for an easy split of utilities. The top floor features a 3-bedroom, 1-bathroom layouts, currently occupied by an excellent tenant paying $2565/month. The lower two unit each contain 2 bedrooms and 1 bathroom, designed with the buyer's comfort in mind. One of these units is also occupied by reliable tenant paying $2565/month. The ground floor unit is prepared for move-in. Featuring high ceilings, marble counters, and stainless-steel appliances, this property is a rare opportunity. Each floor has a 23 by 50 feet layout, located on a large lot. The exterior consists of a spacious private driveway and 2 garage spaces, offering a hassle-free daily routine and giving buyers an extra outdoor space to enjoy the neighborhood. The property is located in a prime location for commuters, being only a short walk away from the 6 train and an easy drive over to major highways. Don't miss out on this chance for a new start at 1616 Pilgrim Avenue; book your private viewing today!

1616 Pilgrim Avenue, Bronx

$520,000

3 Beds ⋅ 2 Baths ⋅ 1031933 MLS

Welcome to this charming detached single-family home situated on a desirable corner lot in the heart of the Williamsbridge neighborhood of the Bronx. Offering 3 bedrooms and 2 full bathrooms, this home presents a wonderful opportunity to create the space of your dreams. The primary suite features a private en-suite bathroom complete with a relaxing whirlpool tub—perfect for unwinding after a long day. While the property could benefit from some refreshing and cosmetic updates, it boasts solid bones and is ideal for buyers looking to add their own style and value. Conveniently located near shopping, parks, public transportation, and a variety of neighborhood amenities, this home also offers the added benefit of several schools within walking distance. Don’t miss this opportunity to own a detached home with a private yard on a corner lot in one of the Bronx’s most established neighborhoods. With a little vision and TLC, this property can truly shine! Please do not disturb the sellers.

801 E 215th Street, Bronx

$399,000

1 Beds ⋅ 1 Baths ⋅ 1032454 MLS

A must see! The paint is still fresh!!! 6334 Fresh Pond is located in the major hub of Ridgewood and close to various transportation. This luxury condominium building includes: a gym, pet grooming spa, bike/package room, storage cages, elevator and a furnished roof terrace area offering picturesque views of Manhattan. This newly constructed unit includes Stainless Oven, Microwave & Dishwasher, Stainless Whirlpool Refrigerator, Blonde Walnut Hard Wood Flooring, White Marble and Grey Colored Bathroom, Gourmet Style Kitchen with Quartz Countertops and Backsplash, Modern White Kitchen Cabinetry, and an oversized kitchen island for that extra serving area as well as seating. For an added convenience, there is a washer and dryer in this unit. The unit offers an abundance of sunlight and is conveniently located on the first floor. This unit will not last, please call for your viewing today.

6334 Fresh Pond Road Unit #1A, Ridgewood

Start Your Search

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.