Real estate listing script (single complany, simple script)

Quote from: coroico at Jun 30, 2010, 05:00 AM

basically what is required:
categories (3–4 with possibility to add more)
listing page
details page (with pdf functionality, add to favorites, send to friend)
filter (search: by price, type and a more advanced search as here http://property.viriko.com)

If categories, price, type, ... are TVs, the filtering can be done by AjaxSearch 191 + a short customization.
For the details of the listing page, you need to define the tplResult and may be the tplGrpResult.

See the AjaxSearch customization demo pages. For instance this one

cool, worth testing!

as for me I was stating with AjaxSearch but switched to Ditto enabling me to use more flexible filter way that time

Just for fun, a real estates search example based on AjaxSearch 1.9.1 Look at this demo page.

Oops...

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Operand should contain 1 column(s) »
SQL: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, ntv1.value AS reState, ntv2.value AS rePrice, ntv3.value AS reType, ntv4.value AS reListingType, ntv5.value AS rePhoto_thmb FROM `mdx1_site_content` sc LEFT JOIN( SELECT DISTINCT tv1.contentid , tv1.value FROM `mdx1_site_tmplvar_contentvalues` tv1 WHERE tv1.tmplvarid = ’20’ ) AS ntv1 ON sc.id = ntv1.contentid LEFT JOIN( SELECT DISTINCT tv2.contentid , tv2.value FROM `mdx1_site_tmplvar_contentvalues` tv2 WHERE tv2.tmplvarid = ’22’ ) AS ntv2 ON sc.id = ntv2.contentid LEFT JOIN( SELECT DISTINCT tv3.contentid , tv3.value FROM `mdx1_site_tmplvar_contentvalues` tv3 WHERE tv3.tmplvarid = ’23’ ) AS ntv3 ON sc.id = ntv3.contentid LEFT JOIN( SELECT DISTINCT tv4.contentid , tv4.value FROM `mdx1_site_tmplvar_contentvalues` tv4 WHERE tv4.tmplvarid = ’33’ ) AS ntv4 ON sc.id = ntv4.contentid LEFT JOIN( SELECT DISTINCT tv5.contentid , tv5.value FROM `mdx1_site_tmplvar_contentvalues` tv5 WHERE tv5.tmplvarid = ’34’ ) AS ntv5 ON sc.id = ntv5.contentid WHERE ((sc.id IN (269,270,271,272,273,274,275,276,277,278,280)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.privateweb=0)) GROUP BY sc.id HAVING ((reType =’Single Family Home’) AND (reState =’West Virginia’) AND (reListingType =’Buy’) AND (rePrice > 50,000 AND rePrice < 80,000)) ORDER BY rePrice
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0401 s (20 Requests)
PHP: 0.2126 s
Total: 0.2528 s

arghhh ... US currency format with a comma !!! How could you imagine get a property for 50$ or 80 $

Fixed with a more relevant checking of the currency input field.