My Company's Active Listings

$799,000 (USD)
Pending

Baychester Area Multi-Family Home

Pending

3121 Mickle Avenue Bronx, NY 10469

4 Bed
3 Baths
1461 sqft
MLS# 980504
This exceptional legal two-family home offers the ideal combination of modern living and classic charm. Featuring two spacious 2-bedroom units with private parking for 1 vehicle, each offering it own unique appeal. Located in a desirable neighborhood of the Bronx, this property is perfect for investors, multi-generational living, first time home buyers, or anyone looking for a home with rental income potential.

Unit 1: Fully renovated for modern living! Step into this beautifully renovated 2-bedroom, 2-bathroom unit, where contemporary design meets comfort. From the sleek kitchen with brand new stainless steel appliances to the updated flooring and fixtures throughout. Every inch of this unit has been thoughtfully redesigned. Enjoy the open concept living and dining area, perfect for entertaining, and relax in the spacious bedroom with ample closet space. The updated bathroom features modern finishes making this unit move-in ready with no work required.

Unit 2: Well-maintained with recent updates. The second floor 2-bedroom, 1-bathroom unit is in great condition and offers a great opportunity for a homeowner to add their personal touch or move right in. With its original charm complimented with recent upgrades, this unit offers solid potential rental income or a space to raise your family. The kitchen and bathroom are functional, and the cozy bedrooms provide plenty of space to create your ideal living environment.

Each unit pays their own utilities and have completely separated heating and hot water units allowing for peace of mind. Additionally, both units have access to the spacious backyard as the property is semi detached and has a fully concrete walkway from the front of the property to the back.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Kingsland Properties
$799,000 (USD)
Active

Maplewood Twp Area Single Family Home

Active

3 Northview Ter Maplewood Twp., NJ 07040

3 Bed
2 Baths
1539 sqft
MLS# 4040221
Welcome to this spacious and inviting home in the highly desirable, high-demand town of Maplewood! Offering 3 generously sized bedrooms, 1 full bathroom, and 1 half bathroom, this colonial style home provides the perfect blend of comfort, functionality and rare opportunity to create your vision. The kitchen offers plenty of space for cooking and gathering, while the separate formal dining room is ideal for hosting holidays and special occasions.Relax year-round in the cozy enclosed porch/sunroom overlooking the private backyard?an ideal space for morning coffee, reading, or entertaining. The large attached garage features an additional storage area, providing ample room for vehicles, tools, and outdoor equipment.The expansive unfinished basement boasts high ceilings and endless potential to create a recreation room, home office, gym, or additional living space tailored to your needs.Recent updates provide added peace of mind, including a brand-new water heater, two new sump pumps, and a furnace professionally serviced in 2026.Ideally located just one mile from vibrant downtown Maplewood, you'll enjoy easy access to boutique shopping, gourmet restaurants, cafs, and the direct train to Midtown Manhattan, making this home perfect for commuters seeking suburban charm with city convenience.With its generous living spaces, desirable location, private backyard, and outstanding potential, this is a rare opportunity to own a home in one of New Jersey's most sought-after communities!
Listing Courtesy of GARDEN STATE MLS - IDX / Listed By: Thomas Borowski, Howard Hanna | Rand Realty
$799,000 (USD)
Active

Bloomingburg Area Single Family Home

Active

4 Rachel Court Bloomingburg, NY 12721

3 Bed
4 Baths
3148 sqft
MLS# 999407
Virtual Tour
Tucked away on a quiet cul-de-sac in the sought-after Winterton section of Bloomingburg, New York, 4 Rachel Court offers an exceptional blend of luxury, comfort, and convenience. This expansive 3,148 sq. ft. residence features 3 spacious bedrooms and 3 full baths, thoughtfully designed for both everyday living and upscale entertaining. At the heart of the home is a true chef’s kitchen, equipped to inspire culinary creativity, while the open layout flows seamlessly into inviting living spaces framed by breathtaking, billion-dollar views of the surrounding Hudson Valley landscape. The primary suite is a private retreat, complete with a spa-like master bath featuring a jetted tub and steam shower—perfect for unwinding at the end of the day. The lower level provides a fully finished basement with a second kitchen provides incredible flexibility for extended living, guest accommodations, or entertaining.
Additional highlights include a heated 2.5-car garage, central vacuum system, and a whole-house propane generator for peace of mind year-round. Beyond the home, enjoy the charm and convenience of the local area. You’re just minutes from outdoor destinations like Wurtsboro Ridge State Forest and Basha Kill Wildlife Management Area, perfect for hiking, birdwatching, and nature escapes, Mamakating Town Park, Neversink River, and the Wallkill Golf Club. Nearby Wurtsboro, New York offers quaint shops, dining, and small-town charm, while larger shopping, dining, and entertainment options are easily accessible in Middletown, New York. Commuters will appreciate the easy access to bus and train options to NYC, making this an ideal balance of serene suburban living and city connectivity. Experience elevated living at 4 Rachel Court—where luxury meets lifestyle in the heart of the Hudson Valley.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: June Cosgrove-Hays, Howard Hanna | Rand Realty
$795,000 (USD)
Pending

New City Area Single Family Home

Pending

18 Scott Drive New City, NY 10956

4 Bed
3 Baths
2062 sqft
MLS# 979978
Virtual Tour
New City, NY! This beautifully maintained split-level home offers the perfect blend of comfort, style, and functionality. Featuring 4 spacious bedrooms and 2.5 bathrooms, including a convenient first-floor primary bedroom suite with laundry, this home is designed for both everyday living and entertaining. Hardwood floors flow throughout much of the home, adding warmth and timeless appeal. The kitchen boasts stainless steel appliances, granite countertops, and double ovens, ideal for cooking and hosting. The open floor plan flows seamlessly into a bright and airy living room complete with cathedral ceilings, skylights, and a cozy fireplace. High hat lighting enhances the home’s appeal. Additional highlights include a 1-car garage, sub-basement providing ample storage space, generator installed in 2013, roof replaced in 2010, and an updated HVAC system with the interior unit replaced in January 2026. Step outside to your private backyard oasis featuring an in-ground heated pool, perfect for relaxing or entertaining all summer long. Located in the award-winning Clarkstown Central School District, this home also offers access to all Clarkstown Parks & Recreation facilities, including Germonds Park, which features pools, playgrounds, athletic fields, and miniature golf. Welcome Home!
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Margo Bohlin, Howard Hanna | Rand Realty
$795,000 (USD)
Active

Cottekill Area Single Family Home

Active

374 Marcott Road Cottekill, NY 12419

4 Bed
4 Baths
2704 sqft
MLS# 980386
Experience a private Hudson Valley estate where farmhouse chic meets SoHo inspired edge. Enjoy refined country living blended with sophistication & serene natural beauty on 3 secluded acres. Designed for both comfort and elevated entertaining, this 4 bedroom, 3.5 bath home offers a seamless fusion of modern design and timeless character. The light filled open concept living and kitchen area creates an elegant yet inviting space for gatherings. The full floor primary suite serves as a true haven, while the lower level provides endless flexibility for a home gym, media room or private guest accommodations. Outdoors the property reveals an inviting private sanctuary. Lush manicured grounds are layered with mature perennial plantings, creating texture, color and privacy throughout the seasons. A sweeping wraparound porch invites peaceful afternoons and seamless entertaining in a serene setting. Equestrian and lifestyle amenities are beautifully integrated into the landscape with discretion and intention. A well designed barn with two stalls, wet stall, tack room, and hay loft is complemented by fenced paddocks and a run in shed. A nearby duck pond offers a rare blend of beauty and function with an enclosed kennel area. Bordering the scenic O&W trail, the property provides direct access to miles of riding and cycling through some of the regions most picturesque terrain. Perfectly positioned just minutes from vibrant enclaves of Rosendale, Kingston, and Saugerties known for their acclaimed history, dining, galleries, and boutiques. This home offers both complete privacy and effortless accessibility, with the NYS Thruway nearby. A rare offering where design, land and lifestyle converge with quiet distinction.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Jennifer Loprieno, Howard Hanna | Rand Realty