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: 3 Table List Array Length: 0 Table List String: ,linton_en_listingsdbelements price ,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 price ,linton_en_listingsdbelements sale_rent WHERE (listingsdb_active = 'yes') AND (linton_en_listingsdb.listingsdb_id = price.listingsdb_id) AND (linton_en_listingsdb.listingsdb_id = sale_rent.listingsdb_id) AND (price.listingsdbelements_field_name = 'price' AND CAST(price.listingsdbelements_field_value as signed) >= '600000') 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 price ,linton_en_listingsdbelements sale_rent ,linton_en_listingsdbelements sort0 WHERE (listingsdb_active = 'yes') AND (linton_en_listingsdb.listingsdb_id = price.listingsdb_id) AND (linton_en_listingsdb.listingsdb_id = sale_rent.listingsdb_id) AND (linton_en_listingsdb.listingsdb_id = sort0.listingsdb_id) AND (price.listingsdbelements_field_name = 'price' AND CAST(price.listingsdbelements_field_value as signed) >= '600000') 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 = 600615) 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 = 600615) 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 = 615963) 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 = 615963) 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 = 596841) 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 = 596841) 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 = 607028) 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 = 607028) 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 = 607689) 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 = 607689) 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 = 608755) 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 = 608755) 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 = 603594) 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 = 603594) 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 = 607820) 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 = 607820) 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 = 607782) 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 = 607782) 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 = 613898) 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 = 613898) 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#: 90014028012 List price: $19,500,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms: 5 Full Baths: 9 Half Baths: 0 Levels:
Year Built: MLS#: 90177352137 List price: $17,424,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms:Full Baths:Half Baths:Levels:
Broker: Weber Ghadban & Associates Realty
PATRICKSWELL
Year Built: MLS#: 90136694736 List price: $17,000,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms: 5 Full Baths: 5 Half Baths: 2 Levels:
Year Built: MLS#: 90125944994 List price: $14,950,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms: 7 Full Baths: 8 Half Baths: 3 Levels:
Year Built: MLS#: 10326722070 List price: $12,950,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms:Full Baths:Half Baths:Levels:
Broker: Long & Foster Real Estate, Inc.
POTOMAC OUTSIDE
Year Built: MLS#: 90184572266 List price: $12,500,000 Status: Active HOA Fee:Sale/Rental: Sale Condo Fee: Bedrooms: 9 Full Baths: 10 Half Baths: 4 Levels:
