Sort Type SQL: SELECT listingsformelements_field_type FROM linton_en_listingsformelements WHERE listingsformelements_field_name = 'price' Sort Text: AND (sort0.listingsdbelements_field_name = 'price') Order Text: ORDER BY CAST(sort0.listingsdbelements_field_value as signed) DESC Table List Array Length: 2 Table List Array Length: 0 Table List String: ,linton_en_listingsdbelements sale_rent ,linton_en_listingsdbelements sort0 Listing Count: SELECT COUNT(distinct(linton_en_listingsdb.listingsdb_id)) as total_listings FROM linton_en_listingsdb ,linton_en_listingsdbelements sale_rent WHERE (listingsdb_active = 'yes') AND (linton_en_listingsdb.listingsdb_id = sale_rent.listingsdb_id) AND NOT (linton_en_listingsdb.userdb_id = '41') AND (sale_rent.listingsdbelements_field_name = 'sale_rent' AND sale_rent.listingsdbelements_field_value = 'Y') Search SQL: SELECT distinct(linton_en_listingsdb.listingsdb_id), linton_en_listingsdb.userdb_id, linton_en_listingsdb.listingsdb_title FROM linton_en_listingsdb ,linton_en_listingsdbelements sale_rent ,linton_en_listingsdbelements sort0 WHERE (listingsdb_active = 'yes') AND (linton_en_listingsdb.listingsdb_id = sale_rent.listingsdb_id) AND (linton_en_listingsdb.listingsdb_id = sort0.listingsdb_id) AND NOT (linton_en_listingsdb.userdb_id = '41') AND (sale_rent.listingsdbelements_field_name = 'sale_rent' AND sale_rent.listingsdbelements_field_value = 'Y') AND (sort0.listingsdbelements_field_name = 'price') ORDER BY CAST(sort0.listingsdbelements_field_value as signed) DESC Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 547844) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547844) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547844) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547844) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 183874) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 183874) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 183874) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 183874) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 193838) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 193838) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 193838) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 193838) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 444458) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 444458) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 444458) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 444458) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 369710) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 369710) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 369710) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 369710) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 383978) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 383978) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 383978) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 383978) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 547845) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547845) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547845) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 547845) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 501865) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 501865) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 501865) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 501865) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 288634) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 288634) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 288634) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 288634) AND (listingsdbelements_field_name = 'status')) Listing Data: SELECT listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM linton_en_listingsdbelements, linton_en_listingsformelements WHERE ((listingsdb_id = 558435) AND (listingsformelements_display_on_browse = 'Yes') AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 558435) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 558435) AND (listingsdbelements_field_name = 'status')) Status Lookup for price field: SELECT listingsdbelements_field_value FROM linton_en_listingsdbelements WHERE ((listingsdb_id = 558435) AND (listingsdbelements_field_name = 'status')) Linton Hall, RealtorsLinton Realtors
Listing data provided by Metropolitan Regional Information Service (MRIS) and is from various brokers who participate in the IDX listings system. All information is deemed reliable but not guaranteed, and should be independently verified. Prices, features and availabilities may change without notice. Last MRIS update on
2010-09-07 at 12:17
Year Built: MLS#: PW7396050 List price: $1,099,900 Status: Active HOA Fee: $297 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 0 Full Baths: 5 Half Baths: 0 Levels: 3
Year Built: MLS#: lo7067463 List price: $950,000 Status: Active HOA Fee: $145 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 5 Full Baths: 4 Half Baths: 1 Levels: 3
Year Built: MLS#: PW7172600 List price: $925,000 Status: Active HOA Fee: $0 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 4 Full Baths: 4 Half Baths: 1 Levels: 3
Year Built: MLS#: LO7303672 List price: $800,000 Status: Active HOA Fee: $276 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 5 Full Baths: 4 Half Baths: 3 Levels: 3
Year Built: MLS#: LO7303672 List price: $800,000 Status: Active HOA Fee: $276 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 0 Full Baths: 4 Half Baths: 3 Levels: 3
Year Built: MLS#: PW7271482 List price: $739,900 Status: Active HOA Fee: $0 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 6 Full Baths: 4 Half Baths: 1 Levels: 3
Year Built: MLS#: PW7400115 List price: $725,000 Status: Active HOA Fee: $52 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 0 Full Baths: 4 Half Baths: 1 Levels: 3
Year Built: MLS#: PW7377865 List price: $683,000 Status: Active HOA Fee: $189 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 4 Full Baths: 3 Half Baths: 1 Levels: 3
Year Built: MLS#: PW7232275 List price: $649,900 Status: Active HOA Fee: $65 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 4 Full Baths: 4 Half Baths: 1 Levels: 3
Year Built: MLS#: FX7406525 List price: $634,900 Status: Active HOA Fee: $50 Sale/Rental: Sale Condo Fee: $0 Bedrooms: 0 Full Baths: 2 Half Baths: 1 Levels: 3
