Raw Request:
POST /listings/_search?pretty=true&error_trace=true&typed_keys=true
{"from":0,"query":{"bool":{"filter":[{"terms":{"systemid":[406,407]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"id_listingid":{"operator":"and","query":"430671"}}}]}},"size":25,"sort":[{"date_list":{"order":"desc"}}],"_source":{"includes":["systemid","detailtablename","id_listinguid","id_listingid","id_primarylistingoffice","id_primarylistingofficename","id_primarylistingagent","status_display","location_streetaddress","location_city","location_state","location_postalcode","bedrooms","bathrooms_total","price_list","price_closed","primaryimage","squarefootage","geo_coordinates","type_search","type_transactiontype","type_propertytype","type_status","obj_openhouses","date_list","remarks","flag_*"]}}
Raw Response:
{
"took" : 4,
"timed_out" : false,
"_shards" : {
"total" : 3,
"successful" : 3,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1028444421",
"_score" : null,
"_source" : {
"price_closed" : 155000.0,
"status_display" : "Closed",
"systemid" : 406,
"id_listinguid" : "1028444421",
"id_primarylistingofficename" : "RE/MAX Island Realty",
"type_search" : 2,
"type_propertytype" : 19,
"bathrooms_total" : 0,
"id_primarylistingagent" : "521013",
"date_list" : "2022-11-09T00:00:00",
"type_status" : 4,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "133 Arrow Road, 326",
"location_postalcode" : "29928",
"flag_internetadvertise" : true,
"price_list" : 162000.0,
"id_primarylistingoffice" : "521",
"location_city" : "Hilton Head Island",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -80.75762939453125,
"lat" : 32.16306686401367
},
"id_listingid" : "430671",
"type_transactiontype" : 0
},
"sort" : [
1667952000000
]
}
]
}
}