goreamarrerorealestate.com Search Results

$2,650,000

Set way back from the road is this spacious, 5-Bedroom, 4.5 Bath Contemporary Farmhouse which embodies timeless craftsmanship and country charm. This carefully curated home is a blend of natural stone, hand hewn repurposed Hemlock timber beams, honey colored wide board Pine flooring, fine finishes and efficient systems throughout. inside the front door lies a Great Room with a 25' high cathedral ceiling. Anchoring the ground level and the core of the house, the Great Room features a dramatic field-stone fireplace with a blue stone hearth and roughhewn mantle. French doors off the room lead to a 12' X 10' covered porch overlooking the swimming pool. The open concept layout flows into the chef's Kitchen. There's a Palomino granite topped island with a porcelain farm sink, Bertozzoni stainless dishwasher, ample under counter storage, and counter stools for gathering. Above is a coffered beamed ceiling. The Bertozzoni 6=Burner gas stove with gas grill, gas oven and convection oven, and Frigidaire professional 36 inch stainless side by side refrigerator and freezer are ideal for all the farm to table meal prep and entertaining. A walk-in Pantry with coffee station and shelves for lots of dry storage is nearby. A Breakfast Area for casual meals is jus off the island, but there is also a Dining Room off the Great Room as well. A back hall with a rough hewn Walnut bench, open shelving and outerwear closet. There is also a well appointed Laundry Room with new Maytag Washer & Dryer, polished concrete counter tops, a porcelain farm sink, and built in cabinetry for handy laundry and cleaning supply storage.The ground floor Primary Suite features a 10' x 8' walk-in closet with built in cubby's and double rod hanging storage. This spacious room has pine wide board floors and a coffered, pickled barn-wood ceiling. It adjoins the spacious Primary Bath with marble topped double vanities, walk-in shower with tile surround and blck river pebble floor next to an oversized soaking Kohler tub. The Primary Suite feels like a private retreat with French doors leading out to the pool area.Upstairs above the Primary is a Bedroom Suite with a Full Bath. Crossing back through the Great Room is another wing with 2-Bedrooms each with walk-in closets and a shared Full Bath. Upstairs is an additionally large Bedroom that could serve as a Media Room or Gym. An Office is located on this level with an ensuite Bath. The home's systems are energy efficient including Broud Propane 4-zone heating, 80 gallon hot water heater, whole house, zoned air conditioning with Mitsubishi mini-splits on each wing of the upstairs and a whole-house 22kw generator. Marvin windows throughout. Outside is the 20' X 40' heated mineral pool with blue stone surround. There's also an outdoor Kitchen with hot and cold water, refrigerator, grilles, and counters under a beamed canopy. Landscaped yard is completely fenced. Oversized 2-car garage. Down the drive towards the stone entry pillars is a heritage barn that could be converted into a Studio or Guest House. Whether used as a year-round residence or a seasonal escape, this Contemporary Farmhouse captures the spirit of refined modern living - where comfort, craftsmanship, nature and rural living meet. Ten Minutes to Hudson shopping and galleries and to AmTrak. Just down the road is Morningstar Farm Market with great offerings from their farm and from other local growers and makers. Come see this great property!

5 Beds ⋅ 6 Baths ⋅ 977841 MLS

Set way back from the road is this spacious, 5-Bedroom, 4.5 Bath Contemporary Farmhouse which embodies timeless craftsmanship and country charm. This carefully curated home is a blend of natural stone, hand hewn repurposed Hemlock timber beams, honey colored wide board Pine flooring, fine finishes and efficient systems throughout. inside the front door lies a Great Room with a 25' high cathedral ceiling. Anchoring the ground level and the core of the house, the Great Room features a dramatic field-stone fireplace with a blue stone hearth and roughhewn mantle. French doors off the room lead to a 12' X 10' covered porch overlooking the swimming pool. The open concept layout flows into the chef's Kitchen. There's a Palomino granite topped island with a porcelain farm sink, Bertozzoni stainless dishwasher, ample under counter storage, and counter stools for gathering. Above is a coffered beamed ceiling. The Bertozzoni 6=Burner gas stove with gas grill, gas oven and convection oven, and Frigidaire professional 36 inch stainless side by side refrigerator and freezer are ideal for all the farm to table meal prep and entertaining. A walk-in Pantry with coffee station and shelves for lots of dry storage is nearby. A Breakfast Area for casual meals is jus off the island, but there is also a Dining Room off the Great Room as well. A back hall with a rough hewn Walnut bench, open shelving and outerwear closet. There is also a well appointed Laundry Room with new Maytag Washer & Dryer, polished concrete counter tops, a porcelain farm sink, and built in cabinetry for handy laundry and cleaning supply storage.The ground floor Primary Suite features a 10' x 8' walk-in closet with built in cubby's and double rod hanging storage. This spacious room has pine wide board floors and a coffered, pickled barn-wood ceiling. It adjoins the spacious Primary Bath with marble topped double vanities, walk-in shower with tile surround and blck river pebble floor next to an oversized soaking Kohler tub. The Primary Suite feels like a private retreat with French doors leading out to the pool area.Upstairs above the Primary is a Bedroom Suite with a Full Bath. Crossing back through the Great Room is another wing with 2-Bedrooms each with walk-in closets and a shared Full Bath. Upstairs is an additionally large Bedroom that could serve as a Media Room or Gym. An Office is located on this level with an ensuite Bath. The home's systems are energy efficient including Broud Propane 4-zone heating, 80 gallon hot water heater, whole house, zoned air conditioning with Mitsubishi mini-splits on each wing of the upstairs and a whole-house 22kw generator. Marvin windows throughout. Outside is the 20' X 40' heated mineral pool with blue stone surround. There's also an outdoor Kitchen with hot and cold water, refrigerator, grilles, and counters under a beamed canopy. Landscaped yard is completely fenced. Oversized 2-car garage. Down the drive towards the stone entry pillars is a heritage barn that could be converted into a Studio or Guest House. Whether used as a year-round residence or a seasonal escape, this Contemporary Farmhouse captures the spirit of refined modern living - where comfort, craftsmanship, nature and rural living meet. Ten Minutes to Hudson shopping and galleries and to AmTrak. Just down the road is Morningstar Farm Market with great offerings from their farm and from other local growers and makers. Come see this great property!

5988 Route 9H, Claverack

$550,000

located in the center location of Flushing, New York, 35th Avenue and 146th Street. It is a brand-new 2024 second-floor unit with elevator access, boasting a spacious and efficient layout of 492 sq ft, and spacious 186 sq ft balcony The residence offers exceptional convenience for daily living and commuting: 2-minute walk to Hmart and Great Wall Supermarket, 10-minute walk to the LIRR Murray Hill Station 18-minute walk to the Flushing subway station.

1 Beds ⋅ 1 Baths ⋅ 977870 MLS

located in the center location of Flushing, New York, 35th Avenue and 146th Street. It is a brand-new 2024 second-floor unit with elevator access, boasting a spacious and efficient layout of 492 sq ft, and spacious 186 sq ft balcony The residence offers exceptional convenience for daily living and commuting: 2-minute walk to Hmart and Great Wall Supermarket, 10-minute walk to the LIRR Murray Hill Station 18-minute walk to the Flushing subway station.

14610 35th Avenue Unit #2D, Flushing

$299,990

Welcome to this beautifully fully renovated 1-bedroom co-op located on the desirable 4th floor, offering excellent natural light throughout the day. The thoughtfully updated windowed kitchen features elegant marble countertops, modern cabinetry, and stainless steel appliances, providing both style and functionality with great ventilation. This home boasts engineered wood flooring throughout and a smart, efficient layout. The oversized bedroom offers exceptional space, easily accommodating a large bed along with additional furniture or a work-from-home setup. Multiple closets provide ample storage, making everyday living comfortable and convenient. Situated in a well-maintained elevator building, this home is perfectly located near shopping, dining, and daily essentials. Prime Location for Commuters: Just a short walk (approx. 8–10 minutes) to the E/F subway lines and the Kew Gardens LIRR station, offering a fast and convenient commute to Manhattan — as quick as 15 minutes via LIRR. Move-in ready condition — a rare find in the area. Don’t miss this opportunity to own your dream home!

1 Beds ⋅ 1 Baths ⋅ 975509 MLS

Welcome to this beautifully fully renovated 1-bedroom co-op located on the desirable 4th floor, offering excellent natural light throughout the day. The thoughtfully updated windowed kitchen features elegant marble countertops, modern cabinetry, and stainless steel appliances, providing both style and functionality with great ventilation. This home boasts engineered wood flooring throughout and a smart, efficient layout. The oversized bedroom offers exceptional space, easily accommodating a large bed along with additional furniture or a work-from-home setup. Multiple closets provide ample storage, making everyday living comfortable and convenient. Situated in a well-maintained elevator building, this home is perfectly located near shopping, dining, and daily essentials. Prime Location for Commuters: Just a short walk (approx. 8–10 minutes) to the E/F subway lines and the Kew Gardens LIRR station, offering a fast and convenient commute to Manhattan — as quick as 15 minutes via LIRR. Move-in ready condition — a rare find in the area. Don’t miss this opportunity to own your dream home!

12010 85th Avenue Unit #4J, Kew Gardens

$4,950,000

Exquisite Custom-Built Luxury Residence This extraordinary 5-bedroom, 7-bathroom masterpiece spans four full floors of refined living space and was custom built by a builder for himself — showcasing exceptional craftsmanship, expertise, and uncompromising attention to detail throughout. Designed for both grand entertaining and private comfort, this home features soaring 11-foot ceilings, private en-suite bathrooms, and expansive living areas flooded with natural light. The fully finished entertainment level is a destination of its own, offering: • Indoor Olympic-style swimming pool • Private spa • Sauna • Fully equipped gym • Dedicated entertainment/media room • Additional recreation space Every material and finish in this home is top-of-the-line — thoughtfully selected with quality, longevity, and elegance in mind. Perfectly situated in a highly convenient location close to: ?? Shops ?? Restaurants ?? Houses of worship ?? Schools ?? Major highways ?? And more This is not just a home — it is a private luxury retreat designed for elevated living.

5 Beds ⋅ 8 Baths ⋅ 966166 MLS

Exquisite Custom-Built Luxury Residence This extraordinary 5-bedroom, 7-bathroom masterpiece spans four full floors of refined living space and was custom built by a builder for himself — showcasing exceptional craftsmanship, expertise, and uncompromising attention to detail throughout. Designed for both grand entertaining and private comfort, this home features soaring 11-foot ceilings, private en-suite bathrooms, and expansive living areas flooded with natural light. The fully finished entertainment level is a destination of its own, offering: • Indoor Olympic-style swimming pool • Private spa • Sauna • Fully equipped gym • Dedicated entertainment/media room • Additional recreation space Every material and finish in this home is top-of-the-line — thoughtfully selected with quality, longevity, and elegance in mind. Perfectly situated in a highly convenient location close to: ?? Shops ?? Restaurants ?? Houses of worship ?? Schools ?? Major highways ?? And more This is not just a home — it is a private luxury retreat designed for elevated living.

Jamaica

$1,588,000

50×95 Large Lot | Fully Gut-Renovated Brick Home in Prime North Flushing Situated on an impressive 4750 ft lot, this rare North Flushing brick residence has been fully gut-renovated inside and out, with everything brand new, offering the feel of new construction while preserving the strength and lasting appeal of solid brick. The home features a functional 4-bedroom, 3 full bath, 1 half bath layout across multiple finished levels, with generous room sizes, abundant natural light, and exceptional flexibility for today’s lifestyle. The first floor includes a welcoming foyer, formal living and dining rooms, a den/family room, a full bath, and a bright sunroom currently converted into a home gym. The second floor offers three well-proportioned bedrooms and a full bath, along with an additional bedroom or family room with its own full bath, creating an ideal setup for privacy and versatility. A full walk-up finished attic adds valuable extra living space and includes a large suite with a full bathroom, while the finished basement provides an open recreation area, half bath, boiler room, and storage. Additional highlights include a private one-car garage, a driveway that fits at least three cars, and a west-facing orientation. Combining a rare oversized lot, like-new condition, and highly flexible layout, this is a standout opportunity in a desirable North Flushing location close to shops, restaurants, parks, and transportation.

4 Beds ⋅ 4 Baths ⋅ 963583 MLS

50×95 Large Lot | Fully Gut-Renovated Brick Home in Prime North Flushing Situated on an impressive 4750 ft lot, this rare North Flushing brick residence has been fully gut-renovated inside and out, with everything brand new, offering the feel of new construction while preserving the strength and lasting appeal of solid brick. The home features a functional 4-bedroom, 3 full bath, 1 half bath layout across multiple finished levels, with generous room sizes, abundant natural light, and exceptional flexibility for today’s lifestyle. The first floor includes a welcoming foyer, formal living and dining rooms, a den/family room, a full bath, and a bright sunroom currently converted into a home gym. The second floor offers three well-proportioned bedrooms and a full bath, along with an additional bedroom or family room with its own full bath, creating an ideal setup for privacy and versatility. A full walk-up finished attic adds valuable extra living space and includes a large suite with a full bathroom, while the finished basement provides an open recreation area, half bath, boiler room, and storage. Additional highlights include a private one-car garage, a driveway that fits at least three cars, and a west-facing orientation. Combining a rare oversized lot, like-new condition, and highly flexible layout, this is a standout opportunity in a desirable North Flushing location close to shops, restaurants, parks, and transportation.

29-35 162nd Street, Flushing

$1,284,999

The best-value 2-bedroom condo for sale in Greenpoint — and the first resale at Parker House. This pristine 2-bedroom, 2-bathroom home offers just under 1,000 sq ft of move-in-ready living and low monthly carrying costs. Built in 2022 and lightly used, every original finish remains intact - no renovation needed, no sponsor premium. Floor-to-ceiling windows frame skyline views and fill the open living space with morning light. The kitchen features Calacatta quartz countertops, Miele and Bosch appliances, soft-close cabinetry and an eat-in peninsula. A split-bedroom layout provides maximum privacy. The king-sized primary suite includes a generous closet and private en-suite bathroom with glass-enclosed walk-in shower and Grohe fixtures. A second full bathroom with deep soaking tub serves as a stylish guest bath. Deeded storage. In-unit washer/dryer. Wide-plank oak floors. High ceilings. Custom built-ins throughout. Parker House Boutique 24-unit elevator Brooklyn condo with communal rooftop deck, virtual doorman, bike storage and package room. Steps to the shops, restaurants and cafés along Manhattan Avenue and Franklin Street, McCarren Park, the NYC Ferry and the G train.

2 Beds ⋅ 2 Baths ⋅ 963724 MLS

The best-value 2-bedroom condo for sale in Greenpoint — and the first resale at Parker House. This pristine 2-bedroom, 2-bathroom home offers just under 1,000 sq ft of move-in-ready living and low monthly carrying costs. Built in 2022 and lightly used, every original finish remains intact - no renovation needed, no sponsor premium. Floor-to-ceiling windows frame skyline views and fill the open living space with morning light. The kitchen features Calacatta quartz countertops, Miele and Bosch appliances, soft-close cabinetry and an eat-in peninsula. A split-bedroom layout provides maximum privacy. The king-sized primary suite includes a generous closet and private en-suite bathroom with glass-enclosed walk-in shower and Grohe fixtures. A second full bathroom with deep soaking tub serves as a stylish guest bath. Deeded storage. In-unit washer/dryer. Wide-plank oak floors. High ceilings. Custom built-ins throughout. Parker House Boutique 24-unit elevator Brooklyn condo with communal rooftop deck, virtual doorman, bike storage and package room. Steps to the shops, restaurants and cafés along Manhattan Avenue and Franklin Street, McCarren Park, the NYC Ferry and the G train.

183 McGuinness Boulevard Unit #3A, Brooklyn

$1,950,000

Spacious 5- bedroom colonial featuring a large entry foyer, open concept formal living room, formal dining room. Chefs eat-in kitchen offers ample workspace and storage. Main level includes den or optional bedroom, perfect for guests or home office. Upper level boasts a primary suite with en-suite bath and generous closets, plus three additional spacious bedrooms and full bath. Finished basement provides extra living or recreational space. One car garage. Enjoy outdoor living on the large deck, surrounded by beautiful mature trees and lush shrubs. A wonderful place to call home

5 Beds ⋅ 3 Baths ⋅ 960134 MLS

Spacious 5- bedroom colonial featuring a large entry foyer, open concept formal living room, formal dining room. Chefs eat-in kitchen offers ample workspace and storage. Main level includes den or optional bedroom, perfect for guests or home office. Upper level boasts a primary suite with en-suite bath and generous closets, plus three additional spacious bedrooms and full bath. Finished basement provides extra living or recreational space. One car garage. Enjoy outdoor living on the large deck, surrounded by beautiful mature trees and lush shrubs. A wonderful place to call home

607 Lanett Avenue, Far Rockaway

$2,195,000

Custom built split ranch, featuring a grand entry foyer with elegant formal living room, enjoy entertaining in the banquet sized formal dining room and stunning kitchen with granite countertops, center island, stainless steel appliances, double ovens, and two sinks. A charming breakfast area opens to a spacious den with fireplace, with patio doors leading to deck. The luxurious primary suite offers a private en-suite bathroom and generous closet space. Five additional bedrooms, with room for more, provides ample space for guests, and home office. This home also includes a professional doctor's office suite with separate entrance, ideal for medical, professional, and or home business use. The fully finished basement offers additional living and recreational space. Set on a beautifully manicured, wrap- around property, this home combines functionality and versatility in one exceptional offering

6 Beds ⋅ 3 Baths ⋅ 958281 MLS

Custom built split ranch, featuring a grand entry foyer with elegant formal living room, enjoy entertaining in the banquet sized formal dining room and stunning kitchen with granite countertops, center island, stainless steel appliances, double ovens, and two sinks. A charming breakfast area opens to a spacious den with fireplace, with patio doors leading to deck. The luxurious primary suite offers a private en-suite bathroom and generous closet space. Five additional bedrooms, with room for more, provides ample space for guests, and home office. This home also includes a professional doctor's office suite with separate entrance, ideal for medical, professional, and or home business use. The fully finished basement offers additional living and recreational space. Set on a beautifully manicured, wrap- around property, this home combines functionality and versatility in one exceptional offering

885 Central Avenue, Far Rockaway

$1,499,000

Welcome to this charming and meticulously maintained brick corner property in the heart of St. Albans, NY. Nestled on a spacious 60x100 lot, this bright and sunny home offers a total of 3,504 sq ft of luxurious living space, including a fully finished basement with a separate entrance. The inviting living room features a cozy fireplace, perfect for relaxing evenings, while the large eat-in kitchen is equipped with stainless steel appliances, ideal for culinary enthusiasts. Modern upgrades include new security cameras, a new water heater, and freshly painted interiors. The new custom closets provide ample storage, ensuring everything has its place. Step outside to a beautifully landscaped yard with a new lawn and grass, complemented by a new PVC fence for privacy. The home also boasts a new stainless steel fence and gate, new gutters, and a newly paved sidewalk and concrete surrounding the house. Designed for easy living, the bright, airy rooms are perfect for family gatherings and entertaining friends. With lots of great extras, this move-in-ready home invites you to just bring your bed and move right in, combining suburban tranquility with urban convenience. Schedule your viewing today and make this stunning property your forever home!

4 Beds ⋅ 4 Baths ⋅ 957327 MLS

Welcome to this charming and meticulously maintained brick corner property in the heart of St. Albans, NY. Nestled on a spacious 60x100 lot, this bright and sunny home offers a total of 3,504 sq ft of luxurious living space, including a fully finished basement with a separate entrance. The inviting living room features a cozy fireplace, perfect for relaxing evenings, while the large eat-in kitchen is equipped with stainless steel appliances, ideal for culinary enthusiasts. Modern upgrades include new security cameras, a new water heater, and freshly painted interiors. The new custom closets provide ample storage, ensuring everything has its place. Step outside to a beautifully landscaped yard with a new lawn and grass, complemented by a new PVC fence for privacy. The home also boasts a new stainless steel fence and gate, new gutters, and a newly paved sidewalk and concrete surrounding the house. Designed for easy living, the bright, airy rooms are perfect for family gatherings and entertaining friends. With lots of great extras, this move-in-ready home invites you to just bring your bed and move right in, combining suburban tranquility with urban convenience. Schedule your viewing today and make this stunning property your forever home!

109-39 194th Street, Saint Albans

$615,000

Woodside/Elmhurst along side Queens Blvd, Beautiful nearly New two bedrooms, two bathrooms Condo with stunning Manhattan views of private balcony. Super Bight in every room. Well Deigned kitchen is equipped with SS Appliances. This prime location Conveniently located near the 7, E, F, M, R trains & the Long Island LIRR, Minutes away from Manhattan, An parking spot is available for purchase with a different price!

2 Beds ⋅ 2 Baths ⋅ 941819 MLS

Woodside/Elmhurst along side Queens Blvd, Beautiful nearly New two bedrooms, two bathrooms Condo with stunning Manhattan views of private balcony. Super Bight in every room. Well Deigned kitchen is equipped with SS Appliances. This prime location Conveniently located near the 7, E, F, M, R trains & the Long Island LIRR, Minutes away from Manhattan, An parking spot is available for purchase with a different price!

7009 45th Avenue Unit #7C, Woodside

$1,089,000

Welcome to this exceptionally maintained 4 Bedroom Cape Cod Home! This Bright and Airy home is filled with all amenities and offers a functional layout in a prime Queens location. Upon entering, there's a welcoming Dining room with a Bay window on the left, complemented by a newly designed Marble Kitchen featuring Stainless Steel Appliances, ample Cabinets, and an abundance of sunlight. Two spacious Bedrooms with Closets, windows, and new wood floors, and a full Bathroom complete the 1st floor. The 2nd floor has 2 huge Bedrooms, a full Bathroom, lots of windows, and a high ceiling. Down to the open Basement through a designed stairway is a Laundry room, a half Bath, and a Boiler room. The Backyard features a huge Deck to enjoy the Summer evenings. Located at School District 26, this house is within walking distance to Union Tpke, Buses, Shopping Centers, Close to Queens County Farm Park, Schools, the Cross Island Expressway, Golf course, and more.

4 Beds ⋅ 3 Baths ⋅ 904525 MLS

Welcome to this exceptionally maintained 4 Bedroom Cape Cod Home! This Bright and Airy home is filled with all amenities and offers a functional layout in a prime Queens location. Upon entering, there's a welcoming Dining room with a Bay window on the left, complemented by a newly designed Marble Kitchen featuring Stainless Steel Appliances, ample Cabinets, and an abundance of sunlight. Two spacious Bedrooms with Closets, windows, and new wood floors, and a full Bathroom complete the 1st floor. The 2nd floor has 2 huge Bedrooms, a full Bathroom, lots of windows, and a high ceiling. Down to the open Basement through a designed stairway is a Laundry room, a half Bath, and a Boiler room. The Backyard features a huge Deck to enjoy the Summer evenings. Located at School District 26, this house is within walking distance to Union Tpke, Buses, Shopping Centers, Close to Queens County Farm Park, Schools, the Cross Island Expressway, Golf course, and more.

7734 Little Neck Parkway, Glen Oaks