Real Estate Cloud Web Services


Property.search



Method: GET or POST

Database object: [db].dbo.mls_simple_search

Sample Query: SELECT * FROM sf.dbo.mls_simple_search WHERE list_price >= list_price_min AND list_price <= list_price_max


Request Fields


API Field DB Field Type
list_no list_no varchar
type prop_type varchar
status status varchar
town_name town_name varchar
area_name area_name varchar
neighborhood_id gis_neighborhood_id int
list_price_min list_price int
list_price_max list_price int
beds_min bedroom_count int
beds_max bedroom_count int
baths_min full_bathroom_count int
baths_max full_bathroom_count int
total_area_min total_area int
total_area_max total_area int
list_date_min list_date date
list_date_max list_date date

Sample Response


{
    "status" : "OK",
    "error" : [{
        "error_no" : 8,
        "error_msg" : "You must be granted a valid key for recloud.me"
    }],
    "meta" : [{
        "results_count" : 104,
        "page_count" : 11,
        "current_page" : 2,
        "per_page" : 10,
        "request_time" : 1.14159,
        "next_page_url" : http://api.recloud.me/1.0/sf/property.search?api_key=xyz1234&list_price_min=500000&list_price_max=750000&page=1,
        "prev_page_url" : http://api.recloud.me/1.0/sf/property.search?api_key=xyz1234&list_price_min=500000&list_price_max=750000&page=3,
    }],
    "request_url" : "http://api.recloud.me/1.0/sf/property.search?api_key=xyz1234&list_price_min=500000&list_price_max=750000",
    "results" : [{
        "261942" : {
            "row_id":"151885",
            "list_no":"261942",
            "prop_type":"CC",
            "lat":37.630213,
            "lon":-122.431496,
            "address1":"406 Boardwalk Dr",
            "UNIT_NO":"14",
            "address2":"San Bruno, CA",
            "postal_code":"94066",
            "town_name":"San Bruno",
            "area_name":"San Bruno",
            "sale_price":"0.00",
            "list_price":249950,
            "total_area":547,
            "bedroom_count":1,
            "full_bath_count":1,
            "half_bath_count":0,
            "hoa_fee":"199.00",
            "tax_year":null,
            "list_date":"2004-01-29",
            "update_date":"2004-03-04T14:22:33",
            "status":"UAG",
            "agent_name":"Leigh Whitten",
            "office_name":"Coldwell Banker Res. R.E. Serv"
        },
        "389154" : {
            "row_id":"264007",
            "list_no":"389154",
            "prop_type":"SF",
            "lat":37.745831,
            "lon":-122.500862,
            "address1":"2195 42nd Ave",
            "UNIT_NO":null,
            "address2":"San Francisco, CA",
            "postal_code":"94116",
            "town_name":"San Francisco",
            "area_name":"Outer Parkside",
            "sale_price":"0.00",
            "list_price":599000,
            "total_area":1214,
            "bedroom_count":3,
            "full_bath_count":2,
            "half_bath_count":0,
            "hoa_fee":"0.00",
            "tax_year":null,
            "list_date":"2011-09-07",
            "update_date":"2011-09-07T09:25:41.7",
            "status":"ACT",
            "agent_name":"Justin Sisco",
            "office_name":"Gaetani Real Estate, Inc."
        },
        "388851" : {
            "row_id":"263797",
            "list_no":"388851",
            "prop_type":"CC",
            "lat":37.74749,
            "lon":-122.507462,
            "address1":"2090 Great Highway",
            "UNIT_NO":"102",
            "address2":"San Francisco, CA",
            "postal_code":"94116",
            "town_name":"San Francisco",
            "area_name":"Outer Parkside",
            "sale_price":"0.00",
            "list_price":389000,
            "total_area":996,
            "bedroom_count":2,
            "full_bath_count":2,
            "half_bath_count":0,
            "hoa_fee":"536.42",
            "tax_year":null,
            "list_date":"2011-08-29",
            "update_date":"2011-09-07T23:00:42",
            "status":"ACT",
            "agent_name":"Debbie Herzfeld",
            "office_name":"Paragon Real Estate Group"
        }
    }]
}