ffd_listing_title | Equestrian Elegance |
---|---|
ffd_unique_id | |
ffd_mls_id | |
ffd_salesforce_id | a0E6g000008NY36EAG |
ffd_address_pb | 3424 S Ramshorn Drive |
address | 3424 S Ramshorn Drive |
baths | 8 |
beds | 6 |
ffd_city_pb | Fremont |
ffd_colistingagent_pb | 0036g00001o7PDhAAM |
ffd_colistingagentemail_pb | |
ffd_colistingagentmlsid | |
ffd_colistingagentname | |
ffd_colistingofficemlsid | |
ffd_colistingofficename_pb | |
ffd_country_pb | United States |
ffd_createddate | 2022-03-29T16:21:14.000+0000 |
about | A Truly Unique, “Must See” Country Estate. Featuring six Bedrooms and eight Bathrooms. This spacious estate home is nestled among 20 acres of serenelandscaping with water feature, a pond and pastures. It is the perfect retreat from the hustle and bustle of life. Get ready to entertain, as this estate boastsover 10,000 sq. ft. of living space, inclusive of two kitchens, four custom subzero refrigerators, a bonus room, and walk-out basement. The newly remodeledupper floor features new hardwood flooring and carpets. The land on the estate has three outbuildings, allowing for plenty of storage space with oneoutbuilding doubling as a commercial catering Kitchen (Kitchen Equipment is negotiable). This property is the perfect investment, as it has previously beenused as an equestrian estate and includes a heated barn with two stalls and small holding paddocks. With Deeded Access to (all sports) Forth Lake andclose to Fremont and Second Lake, summers can be full of outdoor entertainment. Close to Grand Rapids entertainment, museums and nightlife yet farenough for secluded tranquility. |
ffd_displayaddress | |
floor | |
ffd_halfbathrooms_pb | |
ffd_hide_address_on_site | |
ffd_key_words | Fremont; Fremont, MI; Newaygo, MI; Equestrian; Fremont Equestrian; Newaygo, Equestrian; USA; Michigan |
ffd_lastmodifieddate | 2023-01-13T13:54:18.000+0000 |
lat | 43.49351 |
ffd_listofficemlsid | |
ffd_listofficename | |
ffd_listingagent_pb | 0036g00001o7PEpAAM |
ffd_listing_agent_email | |
ffd_listing_agent_firstname | |
ffd_listing_agent_lastname | |
ffd_listingagentmlsid | |
ffd_listingagentname | |
ffd_listing_agent_website | |
price | 2500000 |
ffd_listingtype | Sale |
location | Fremont, Michigan, United States |
lng | -85.93483 |
sq_feet | |
ffd_non_member_paid | |
ffd_other_currency_amount | 2500000 |
ffd_other_currency_type | USD |
ffd_ownerid | 0056g000007BRxxAAG |
ffd_pool_pb | |
ffd_price_upon_request | |
building_type | Single Family |
ffd_id | a0E6g000008NY36EAG |
ffd_totalarea_pb | 7042 |
ffd_solddate | |
ffd_soldprice | |
ffd_state_pb | Michigan |
ffd_status | Active |
ffd_unit_of_measure | Square Feet |
ffd_brokerage_id | 0016g000023ikQOAAY |
year_built | 1990 |
ffd_postalcode_pb | |
pba__WebsiteId__c | 181771 |
pba__Listing_Website__c | https://www.forbesglobalproperties.com/listings/equestrian-elegance |
Site_Post_Id__c | 181771 |
ffd_media | a:7:{i:0;s:105:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/k7mq5mnmv/DJI_0833-2.jpg";i:1;s:113:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/zdbzu3et8/DJI_0882%20%282%29.jpg";i:2;s:113:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/jlglo0gp2/DJI_0951%20%282%29.jpg";i:3;s:113:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/ehcwqu0i2/IMG_8482%20%282%29.jpg";i:4;s:113:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/hbo8itzfh/P9100019%20%281%29.jpg";i:5;s:112:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/rr24p4mvz/Resized_DJI_0819.jpeg";i:6;s:112:"https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/rn7wttnnz/Resized_DJI_0881.jpeg";} |
_thumbnail_id | 181772 |
ffd_featured_image | https://s3.amazonaws.com/propertybase-clients/00D6g000007OY6LEAW/a0O6g000008Ujbp/k7mq5mnmv/DJI_0833-2.jpg |
agents | a:2:{i:0;s:6:"181805";i:1;s:6:"181764";} |
ffd_record_is_deleted | |
ffd_threequarterbathrooms | |
featured_images | 181772 |
listing_images | a:7:{i:0;s:6:"181772";i:1;s:6:"181773";i:2;s:6:"181774";i:3;s:6:"181775";i:4;s:6:"181776";i:5;s:6:"181777";i:6;s:6:"181778";} |
_sbi_oembed_done_checking | 1 |
post_member_id | 181761 |
post_agent_id | 181805 |
post_coagent_id | 181764 |
Equestrian Elegance
Fremont, Michigan, United States
Status: Active
A Truly Unique, “Must See” Country Estate. Featuring six Bedrooms and eight Bathrooms. This spacious estate home is nestled among 20 acres of serenelandscaping with water feature, a pond and pastures. It is the perfect retreat from the hustle and bustle of life. Get ready to entertain, as this estate boastsover 10,000 sq. ft. of living space, inclusive of two kitchens, four custom subzero refrigerators, a bonus room, and walk-out basement. The newly remodeledupper floor features new hardwood flooring and carpets. The land on the estate has three outbuildings, allowing for plenty of storage space with oneoutbuilding doubling as a commercial catering Kitchen (Kitchen Equipment is negotiable). This property is the perfect investment, as it has previously beenused as an equestrian estate and includes a heated barn with two stalls and small holding paddocks. With Deeded Access to (all sports) Forth Lake andclose to Fremont and Second Lake, summers can be full of outdoor entertainment. Close to Grand Rapids entertainment, museums and nightlife yet farenough for secluded tranquility.







Listing Agent
Array
181805 |

Dr. Lora Higdon
LIC.# 6502424669
181764 |

Patricia Ratner
LIC.# 6501433163