Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1610 Yellow Brick Road
Astor, FL 32102
Warren Freeman with Coldwell Banker Coast Realty, original listing - (321) 383-3330

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $874,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 4871 Square Feet
Agency: Coldwell Banker Coast Realty
Agency Phone: (321) 383-3330

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Stunning Waterfront Retreat with Luxurious Amenities and Unmatched Views<br /> Astor, FL<br /> <br /> Nestled in the serene beauty of Astor, this exceptional 5-bedroom, 3-bathroom waterfront home offers a perfect blend of luxury, comfort, and natural charm. With breathtaking views of the canal that leads to the St. Johns River, this meticulously designed residence is an oasis of relaxation and sophistication. This property also presents a fantastic opportunity as a Bed & Breakfast or VRBO rental, thanks to its spacious layout and prime location.<br /> <br /> Key Features:<br /> Expansive Waterfront Deck: Step out to a spacious deck that's ideal for entertaining or unwinding while enjoying the tranquil water views. The inviting sitting area is perfect for gathering with family and friends, or simply soaking in the peaceful surroundings.<br /> <br /> First-Floor Primary Suite: A true retreat, the luxurious primary bedroom features French doors that open to a private covered patio overlooking the water. The oversized ensuite bathroom is a spa-like sanctuary, with a walk-in shower equipped with dual shower heads and a bench, a jetted jacuzzi tub, and two large walk-in closets.<br /> <br /> Gourmet Kitchen & Dining: The remodeled chef's kitchen is a culinary dream, showcasing stunning river stone countertops, high-end appliances, and a spacious walk-in pantry. Its open-concept design seamlessly flows into the living and dining areas, making it ideal for entertaining.<br /> <br /> Open Living Areas & Florida Room: The light-filled living room opens to a sun-soaked Florida room, where panoramic water views create an inviting atmosphere. Whether hosting guests or enjoying quiet time, the open layout offers plenty of space to relax and enjoy nature's beauty.<br /> <br /> Custom Wet Bar: Perfect for entertaining, the custom-built wet bar features seating, a small refrigerator, and ample space for your favorite beverages. It's the ideal spot to socialize while taking in the gorgeous canal views.<br /> <br /> Three AC Units: With three air conditioning units throughout the home, comfort is guaranteed year-round, ensuring that every room maintains the perfect temperature regardless of the season.<br /> <br /> Upgrades & Maintenance: This home has been meticulously maintained, with a newer roof (installed just 3 years ago) and a gutter leaf filter system surrounding the entire property.<br /> <br /> Prime Location & Accessibility: Situated in the peaceful community of Astor, this home offers the ultimate retreat while being conveniently close to major cities including Jacksonville, Daytona, Orlando, and Ocala - all within an hour to an hour and a half drive. Whether you're seeking outdoor adventure, beach days, or urban amenities, everything is within reach.<br /> <br /> The Florida Lifestyle Awaits You<br /> This waterfront gem combines luxurious living with stunning design and practical upgrades. Whether you're looking for a year-round home, a seasonal getaway, or a profitable Bed & Breakfast or VRBO rental, this property offers an unmatched opportunity to live the best of Florida living. Don't miss your chance to make this breathtaking waterfront retreat your forever home!
MlsNumber: --
ListingId: 1037149


Listing Provided By: Coldwell Banker Coast Realty, original listing
Phone: (813) 385-6231
Office Phone: (321) 383-3330
Agent Name: Warren Freeman
Disclaimer: Copyright © 2025 Space Coast Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 358 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Alan Bird - "A man of His Word."  Broker Associate/Realtor GRI, ABR
Alan Bird - "A man of His Word." Broker Associate/Realtor GRI, ABR
ASCIIThe Real Estate Firm of Orlando
Call Today!: (407) 432-8303

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App