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_search":[0,1]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"Walterboro"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"SC","type":"cross_fields"}}]}},"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" : 12,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-210886",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-210886",
"type_search" : 1,
"bathrooms_total" : 1,
"id_primarylistingagent" : "109_2",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "112 Bishop Street",
"flag_internetadvertise" : true,
"price_list" : 150000.0,
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.694444,
"lat" : 32.886101
},
"id_primarylistingofficename" : "Keller Williams Palmetto",
"type_propertytype" : 0,
"date_list" : "2024-03-21T00:00:00",
"location_postalcode" : "29488",
"bedrooms" : 2,
"id_primarylistingoffice" : "109",
"squarefootage" : 947,
"id_listingid" : "210886",
"type_transactiontype" : 0
},
"sort" : [
1710979200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-581109",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-581109",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "15183",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "504 Klein",
"flag_internetadvertise" : true,
"price_list" : 310000.0,
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.675655,
"lat" : 32.897455
},
"id_primarylistingofficename" : "NorthGroup Real Estate LLC",
"type_propertytype" : 0,
"date_list" : "2024-03-15T00:00:00",
"location_postalcode" : "29488",
"bedrooms" : 3,
"id_primarylistingoffice" : "1479",
"squarefootage" : 1500,
"id_listingid" : "581109",
"type_transactiontype" : 0
},
"sort" : [
1710460800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-SBORGA-304675",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-SBORGA-304675",
"id_primarylistingofficename" : "The HomesFinder Realty Group LLC",
"type_search" : 0,
"type_propertytype" : 50,
"bathrooms_total" : 0,
"id_primarylistingagent" : "430250",
"date_list" : "2024-02-02T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "62 Portee Lane",
"location_postalcode" : "29488",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 485000.0,
"id_primarylistingoffice" : "2814",
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.729776,
"lat" : 32.939632
},
"id_listingid" : "304675",
"type_transactiontype" : 0
},
"sort" : [
1706832000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-SBORGA-304824",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-SBORGA-304824",
"id_primarylistingofficename" : "The HomesFinder Realty Group LLC",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "430250",
"date_list" : "2024-02-02T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "62 Portee Lane",
"location_postalcode" : "29488",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 485000.0,
"id_primarylistingoffice" : "2814",
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.729776,
"lat" : 32.939632
},
"id_listingid" : "304824",
"type_transactiontype" : 0
},
"sort" : [
1706832000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1046473951",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 406,
"id_listinguid" : "1046473951",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "320119",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1025 Pellum Road",
"flag_internetadvertise" : true,
"price_list" : 279900.0,
"location_city" : "Walterboro",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -80.761056,
"lat" : 32.860171
},
"id_primarylistingofficename" : "Berkshire Hathaway HomeServices Hilton Head Blufft",
"type_propertytype" : 0,
"date_list" : "2023-10-25T00:00:00",
"location_postalcode" : "29488",
"bedrooms" : 3,
"id_primarylistingoffice" : "106",
"squarefootage" : 1736,
"id_listingid" : "439667",
"type_transactiontype" : 0
},
"sort" : [
1698192000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1045287119",
"_score" : null,
"_source" : {
"systemid" : 406,
"id_listinguid" : "1045287119",
"id_primarylistingofficename" : "Flame Lilly Real Estate Group",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "649004",
"date_list" : "2023-09-15T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "58 Cross Court",
"location_postalcode" : "29488",
"bedrooms" : 4,
"flag_internetadvertise" : true,
"price_list" : 249000.0,
"id_primarylistingoffice" : "649",
"squarefootage" : 1561,
"location_city" : "Walterboro",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -80.642352,
"lat" : 32.907296
},
"id_listingid" : "438751",
"type_transactiontype" : 0
},
"sort" : [
1694736000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-208574",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-208574",
"id_primarylistingofficename" : "Fontaine Real Estate Company, LLC",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "rasbill",
"date_list" : "2023-09-15T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "0 Moore Street",
"location_postalcode" : "29488",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 35000.0,
"id_primarylistingoffice" : "frealestate",
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.667058,
"lat" : 32.898863
},
"id_listingid" : "208574",
"type_transactiontype" : 0
},
"sort" : [
1694736000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-566948",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-566948",
"type_search" : 0,
"bathrooms_total" : 1,
"id_primarylistingagent" : "12801",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "6739 Jefferies Highway",
"flag_internetadvertise" : true,
"price_list" : 275000.0,
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.639797,
"lat" : 32.99171
},
"id_primarylistingofficename" : "Fathom Realty SC LLC",
"type_propertytype" : 19,
"date_list" : "2023-07-20T00:00:00",
"location_postalcode" : "29488",
"bedrooms" : 3,
"id_primarylistingoffice" : "1166",
"squarefootage" : 1738,
"id_listingid" : "566948",
"type_transactiontype" : 0
},
"sort" : [
1689811200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1037996412",
"_score" : null,
"_source" : {
"systemid" : 406,
"id_listinguid" : "1037996412",
"id_primarylistingofficename" : "The Homesfinder Realty Group",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "662021",
"date_list" : "2023-06-02T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "62 Portee Lane",
"location_postalcode" : "29488",
"flag_internetadvertise" : true,
"price_list" : 485000.0,
"id_primarylistingoffice" : "662",
"location_city" : "Walterboro",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -80.729776,
"lat" : 32.939632
},
"id_listingid" : "436157",
"type_transactiontype" : 0
},
"sort" : [
1685664000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1037996284",
"_score" : null,
"_source" : {
"systemid" : 406,
"id_listinguid" : "1037996284",
"id_primarylistingofficename" : "The Homesfinder Realty Group",
"type_search" : 0,
"type_propertytype" : 50,
"bathrooms_total" : 0,
"id_primarylistingagent" : "662021",
"date_list" : "2023-06-02T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "62 Portee Lane",
"location_postalcode" : "29488",
"flag_internetadvertise" : true,
"price_list" : 485000.0,
"id_primarylistingoffice" : "662",
"location_city" : "Walterboro",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -80.729776,
"lat" : 32.939632
},
"id_listingid" : "436161",
"type_transactiontype" : 0
},
"sort" : [
1685664000000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-558047",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-558047",
"type_search" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "12260",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1317 Wolfe Creek Road",
"flag_internetadvertise" : true,
"price_list" : 440000.0,
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.713709,
"lat" : 32.975649
},
"id_primarylistingofficename" : "Keller Williams Preferred",
"type_propertytype" : 19,
"date_list" : "2023-03-02T00:00:00",
"location_postalcode" : "29488",
"bedrooms" : 3,
"id_primarylistingoffice" : "970",
"squarefootage" : 3086,
"id_listingid" : "558047",
"type_transactiontype" : 0
},
"sort" : [
1677715200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-540121",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-540121",
"id_primarylistingofficename" : "Keller Williams Realty",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "12078",
"date_list" : "2022-05-04T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "112 Grayson Street",
"location_postalcode" : "29488",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 20000.0,
"id_primarylistingoffice" : "669",
"location_city" : "Walterboro",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -80.656146,
"lat" : 32.886375
},
"id_listingid" : "540121",
"type_transactiontype" : 0
},
"sort" : [
1651622400000
]
}
]
}
}