Real Estate Site: salperalta.com running on Drupal
Hi folks,
I just wanted to let the community know that I'm running my personal real estate web site on drupal 4.7: www.salperalta.com. It's pretty basic at the moment, but I've only been at it for 15 hours or so, and that includes time spend figuring out how to use drupal_get_form to query an external database with the MLS data set. Will add features and prettify it over time.
Drupal gets better and better the more familiar I get with the API. :^)
Thanks,
Sal
One niggling bug remains with the form:
I'm getting false warnings when using the external rmls database and was wondering if there is a way to suppress the warning or to change the default error handler to something else.
Table 'housing.node_access' doesn't exist query: SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all')) AND grant_view >= 1 in /var/www/sjp/includes/database.mysql.inc on line 121.
I found an old reference to doing such a thing here:
"If you use the db_set_active function to change to another database, and
then run a query that contains invalid syntax, watchdog module tries to
insert the error, but uses the currently active database, instead of
the drupal database."
...
"I use multiple database connections extensively. I set the default error handler to something else whenever I access my other database."
http://lists.drupal.org/pipermail/development/2005-March/002911.html
but nothing yet in the documentation I've been able to work with to fix the problem.
nice site others may
nice site
others may disagree, but i think it'd look a little better if the logo image was changed as such...
http://www.salperalta.com/images/sjp_newer.gif
try removing the silver/grayish background from those 4 circular images and instead having it a plain white background.
That way, there are no breaks in the header... its fluid and those 4 circular images will look great imo.
Hey thanks!
I took your advice, Ben. Good on 'ya.
Wrong value?
At the time of writing, the title on the front page says, "What you can get for ... $700,000 in McMinnville, Oregon" but the house price featured is for $935,000. Looks a little ... odd! ;)
Congrats!
Congratulations, Sal.
I thought i was the only REALTOR considering using Drupal.
I want to take advantage of the community-focus aspect to benefit some
communities in the South Bergen,NJ area.
API? I haven't even considered using the API's yet.
So I can't help you yet with the error.
We are forced to use IDX in order to present MLS info in our website. Are you?
Would you be willing to share your experience on working with the API's?
Your sight is simple and to the point. This is good.
The mortgage block on the left looks a little unclear. Is there an incompatibility between Lending Tree's code and Drupal?
I haven't decided on my own design yet. But once I got it up and running I'll post it hear and send you a separate message as well.
Maybe we can learn from each other?
Tom
--
Thomas Sherlock, SRES
REALTOR Associate
EXIT Golden Realty
"The Conscious Realtor"
tom@SherlockHomz.com
Mob: (201) 362 - 9836
Bus: (201) 997 - 4425
Fax: (201) 997 - 4415
www.EXITGolden.com
Considering a career in Real Estate?
Call me: (201) 362 - 9836
Looks great, How did you
Looks great, How did you create the rollover image effect on RMLS Listings? What modules did you use?
Thanks
Custom Module
H3rnand3z : I just used a javascript rollover and added it into the custom listing module that I wrote to list and display the content from the mls database I'm using.
Thomas: I'm using the IDX data for the web site. I'm having some challenges getting it to list my listings properly for users who are not logged on, though it displays the listings quite nicely. The big challenge to using drupal for listing mls data for me has been integrating the mysql idx database that I use with drupal. The pager_query() api works like a champ with external databases, but the db_rewrite_sql() function appears to be barfing on data pulled from the external dataset for anyone other than the site administrator.
How do you make javascript rollover?
Great real estate website!. Could you elaborate more on how to make an image rollover?
I want to create a new content type called "car" using CCK ;and I want to allow user to upload several images and show image rollover like yours.
http://www.salperalta.com/listing/property?mls=7012121
What module about image should I use to make it work? Pls kindly help.
Well...
Sorry for the late response. I've never used CCK, so I can't help you on that front. What I did was create a custom module for displaying individual property listings. I just whipped up a simple javascript rollover, the elements of which are populated (along with everything else on the listings page) from data pulled from an external database.
Hi Can you tell me how do
Hi
Can you tell me how do you set up this custom search ? (Advanced search)
Sal, what module did you
Sal,
what module did you use for the listings?
Mike.
Custom
Hi there, I wrote a custom module for the listings, which I am currently upgrading and porting to 5.1