Refine Search
Sort by
431 Beach 45th Street, Far Rockaway
$544,900
3 Beds ⋅ 2 Baths ⋅ 1069969 MLS
This 1-family, 3-bedroom home is being sold strictly as-is and is currently occupied with no interior access available. The interior condition is unknown, and all assessments must be based solely on exterior observations. This property presents a unique chance to acquire a home with significant upside potential in a desirable Queens location. Whether your goal is renovation, long-term investment, or creating a customized residence, the property's footprint, location, and overall potential provide a strong foundation for future value. All information is deemed reliable but not guaranteed. Buyers are responsible for independently verifying all information and conducting their own due diligence. Occupants are not to be disturbed. Ideal for experienced purchasers familiar with as-is sales, deferred maintenance, and post-closing occupancy matters. Opportunities like this are increasingly difficult to find. Bring your vision, evaluate the potential, and unlock the value this property has to offer.

431 Beach 45th Street, Far Rockaway

449 Arlington Drive, Ridge
$310,000
2 Beds ⋅ 1 Baths ⋅ 1066893 MLS
Welcome to care-free, vibrant living in the highly sought-after Leisure Village active adult community! Tucked away in a secure, 24-hour gated setting, this beautifully maintained 2-bedroom, 1-bathroom condo unit at 449B Arlington Dr. offers the perfect blend of comfort, convenience, and community. Step inside to a bright, inviting floor plan designed for easy layout configurations and low-maintenance living. The spacious primary bedroom features generous closet space, while the versatile second bedroom is perfect for guests, a dedicated home office, or a cozy den. The clean, functional bathroom accommodates all your daily needs with ease. One of the standout features of this unit is the attached 1-car garage—providing secure parking, shelter from the elements, and excellent extra storage space. As a resident of Leisure Village, you’ll enjoy an unparalleled resort-style lifestyle with access to a wealth of premier amenities. Dive into the sparkling outdoor pool, practice your swing on the community golf course, get creative in the hobby and craft rooms, or socialize with neighbors at the active clubhouse. With basic cable, ground maintenance, trash removal, and snow plowing taken care of by the HOA, you can truly sit back, relax, and enjoy your retirement.

449 Arlington Drive, Ridge

281 Lane St, Hamden
$300,000
3 Beds ⋅ 3 Baths ⋅ 24218242 MLS
Welcome to 281 Lane Street in Hamden! This split-level-style home offers 3 bedrooms, 2.5 bathrooms, and approximately 1,564 square feet of living space, situated on a 0.24-acre lot. The home features a functional layout with generously sized living areas, including a welcoming living room highlighted by a fireplace. The primary bedroom offers the convenience of its own private full bathroom with a stand-up shower. The partially finished lower level provides additional flexibility for a family room, recreation area, home office, or storage, with walk-out access to an enclosed screened-in porch overlooking the backyard. This property presents an excellent opportunity for buyers looking to bring their vision and personal touches while unlocking its full potential. Conveniently located near Dunbar Hill Elementary School, shopping, restaurants, and major commuter routes, this property offers easy access to everyday amenities. Don't miss the opportunity to make this Hamden home your own!

281 Lane St, Hamden

130 Union Road Unit #201, Spring Valley
$2,100,000
8 Beds ⋅ 6 Baths ⋅ 1069027 MLS
New Modern Townhouse of Distinction, Experience sophisticated living in this newly built townhouse offering an impressive 6,410 sq ft of thoughtfully designed space across four full levels, combining architectural elegance, luxury finishes, and modern functionality. Ground Floor – Fully above ground with 9-ft ceilings, this level welcomes you with an oversized foyer, a private study, and a convenient side entrance/mudroom. It also includes a three-bedroom guest suite with two full bathrooms and a beautifully appointed granite kitchen, ideal for extended stays or multi-generational living. Main Floor – The heart of the home features 10-ft ceilings, a sun-filled dining area, and a custom chef’s kitchen with sleek cabinetry, quartz counters, and designer fixtures. A spacious living room with a framed opening for a Huge double skylight brings in abundant natural light, creating a bright and airy atmosphere perfect for entertaining. Top Floor – Upstairs offers five spacious bedrooms, including a grand primary suite with a custom walk-in closet and a spa-inspired bathroom featuring a soaking tub and glass shower. A laundry room customized for buyer, A walk-in linen closet adds additional convenience and storage. Basement – With 9-ft ceilings, large windows, and both interior and exterior access, this versatile level is filled with natural light and can easily accommodate a playroom, gym, or home office. Set on the largest lot in the area, this home showcases premium metal siding, stone pavers, and beautifully landscaped grounds, offering curb appeal that stands out from the rest.

130 Union Road Unit #201, Spring Valley

2 Parkmore St, New Britain
$260,000
3 Beds ⋅ 1 Baths ⋅ 24218180 MLS
This well-built home offers public water, public sewer, and weekly trash pickup. Features include oil heat with steam radiators, a newer furnace and oil tank , newer replacement windows, and vinyl siding. A gas line is available from the street. Offering 1,608 square feet of heated living space per town records, with additional potential square footage in the heated attic rooms. While the home could benefit from some cosmetic updating, it presents a wonderful opportunity to make it your own and bring your vision to life. After all, the one thing you can't change is the location-and this one is fantastic! Outside, enjoy a large, level, cleared yard with plenty of room for family gatherings, gardening, entertaining, or simply relaxing. There is also ample off-street parking as well. Situated in a desirable neighborhood with sidewalks, the property is conveniently located near beautiful 98-acre Walnut Hill Park, featuring a playground, amphitheater, walking and biking trails, tennis courts, and a ballfield.

2 Parkmore St, New Britain

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.

The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.

How much is your home worth?

Get instant property value now!