JSON Data

{
    "propertyId": 2395851,
    "listingId": "400664",
    "feedId": 4,
    "propertyType": "Residential",
    "subTypeName": "Detached",
    "typeId": 10,
    "areaId": 75,
    "subArea": "",
    "bedrooms": 3,
    "bathsFull": 2,
    "bathsHalf": 0,
    "areaName": "Madison",
    "state": "FL",
    "price": 532000,
    "streetAddress": "542 NE Horry Avenue",
    "zipCode": "32340",
    "subDivision": "None",
    "lotDimensions": "",
    "acres": "0.92",
    "yearBuilt": "1966",
    "remarks": "Welcome to this stunning, completely remodeled brick retreat situated on nearly an acre in Madison, Florida. With over 3,000 square feet of thoughtfully designed living space, this 3 bedroom, 2 bath property blends timeless charm with upscale modern finishes in a way that instantly feels warm and inviting. The magazine-worthy kitchen is truly the heart of the house, featuring leathered granite countertops, custom cabinetry, a six-burner gas range, and an incredible butler\u2019s pantry with abundant storage, prep space, and room for two refrigerators. As you move through the living spaces, you\u2019ll notice the comfort and attention to detail in every corner. The cozy gas log fireplace creates the perfect gathering spot, while the bonus room offers flexibility for an office, den, or additional lounge space. The extensive 2022 renovation included new appliances, lighting, doors, hardware, cabinetry, flooring, paint, sheetrock, insulation, and more, creating a seamless blend of character and modern convenience throughout. Step outside and you\u2019ll feel transported to the Tuscan countryside. Grape vines, a fire pit, and beautifully designed outdoor dining and sitting areas create an atmosphere that makes you want to slow down and stay awhile. A two-car carport, whole-house generator hookup, and walk-in basement that is being used as a home gym, add practicality to the beauty, while the overall feeling of the property is something that truly has to be experienced in person. From the moment you walk through the door, this is the kind of place that simply feels like home.",
    "officeName": "The American Dream",
    "officePhone": "850-838-7640",
    "firmId": "9889",
    "agentId": "12139",
    "agentName": "Sarah Pike",
    "agentEmail": "sarahpike@theamericandream.house",
    "agentPhone": "850-673-1292",
    "mlsName": "Tallahassee Board of REALTORS®, Inc.",
    "buildingSqFt": "3057.0",
    "county": "Madison",
    "virtualTourUrl": "https://www.zillow.com/view-imx/bcbcdcff-f43f-4a0b-a638-02ecbb5c847e?setAttribution=mls&wl=true&initialViewType=pano&utm_source=dashboard",
    "lastUpdated": "2026-06-08T02:11:00",
    "ownership": "Standard",
    "lat": 30.475840000000001595026333234272897243499755859375,
    "lng": -83.4136419999999958463376970030367374420166015625,
    "extraData": [
        {
            "displayName": "Appliances",
            "values": "Dishwasher,Ice Maker,Microwave,Oven,Range,Refrigerator"
        },
        {
            "displayName": "Architecturalstyle",
            "values": "Colonial,One Story,Traditional"
        },
        {
            "displayName": "Associationfee",
            "values": "0.0"
        },
        {
            "displayName": "Constructionmaterials",
            "values": "Brick,Vinyl Siding"
        },
        {
            "displayName": "Cooling",
            "values": "Central Air,Ductless,Electric"
        },
        {
            "displayName": "Elementaryschool",
            "values": "Madison County Central School"
        },
        {
            "displayName": "Heating",
            "values": "Central,Electric,Fireplace(s)"
        },
        {
            "displayName": "Highschool",
            "values": "Madison County High School"
        },
        {
            "displayName": "Middleorjuniorschool",
            "values": "Madison County"
        },
        {
            "displayName": "Mlsareamajor",
            "values": "Madison"
        },
        {
            "displayName": "Parkingfeatures",
            "values": "Carport,Two Spaces"
        },
        {
            "displayName": "Propertysubtype",
            "values": "Detached"
        },
        {
            "displayName": "Speciallistingconditions",
            "values": "Standard"
        },
        {
            "displayName": "Subdivisionname",
            "values": "None"
        },
        {
            "displayName": "View",
            "values": "None"
        },
        {
            "displayName": "Waterfrontyn",
            "values": "False"
        }
    ],
    "addedDate": "2026-06-01T17:10:00",
    "listingDate": "2026-06-01T00:00:00",
    "lastPriceChange": "0001-01-01T00:00:00",
    "soldDate": "0001-01-01T00:00:00",
    "soldPrice": 0,
    "priceChanges": [
        {
            "ChangeId": 3088554,
            "Price": 532000,
            "ChangeDate": "2026-06-01T17:10:00",
            "IsInitial": true
        }
    ],
    "status": "Active",
    "compensation_SingleTransactionBroker": null,
    "compensation_NoBrokerageRelationship": null,
    "compensation_IncentiveBonus": null,
    "openHouses": null
}