Brett Property Ltd
  1. Sales
    1. Thinking of Selling
    2. Property Search
  2. Lettings
    1. Thinking of Letting
    2. Property Search
    3. Landlords Information
    4. Tenants Information
    5. Client Money Protection
  3. Commercial
    1. About Us
    2. Commercial Sales
    3. Commercial Lets
  4. Development / Land
  5. Useful Links
  6. Contact
    1. Register
  7. Free Valuation

FIND YOUR NEW PROPERTY

SELECT a.web_address, a.latitude, a.longitude, a.account, a.date_pom, a.ref, a.web_address, a.search_address, a.bathrooms, a.general_desc, a.description2, a.fk_lookup_protyp_id, a.date_pom, a.description3, a.internet_desc, a.postcode, b.description, a.feature1, a.feature2, a.feature3, a.feature4, a.feature5, a.feature6, a.feature7, a.feature8, a.feature9, a.feature10, a.bedrooms, c.reduced, c.under_offer, c.sold_stc, c.asking_price, d.description, e.description, f.description, g.description, a.special_offer, a.special_offer_text, a.date_pom, c.fk_lookup_tentyp_id, h.description FROM tblproperty a, tbllookup_user b, tblproperty_sale_details c, tbllookup_system d, tbllookup_user e, tbllookup_system f, tbllookup_system g, tbllookup_system h WHERE a.active = 1 AND a.market_property = 1 AND a.fk_lookup_locati_id = b.id AND c.fk_property_ref = a.ref AND c.fk_lookup_prista_id = d.id AND c.fk_lookup_prioff_id = e.id AND a.fk_lookup_protyp_id = f.id AND g.id = a.fk_lookup_prosec_id AND h.id = c.fk_lookup_tentyp_id AND c.sold_stc = 0 AND a.fk_lookup_protyp_id NOT IN (153, 608, 558, 151, 152, 573) AND a.fk_lookup_prosec_id <> 93 ORDER BY c.asking_price DESC
  • List
  • Grid
  • Map
Brett_Logo

1 Orion House, Nelson Quay, Milford Haven,

Pembrokeshire SA73 3AZ