If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
On weekends when we are planning on holding an open house, yeah, we still hold them live as well as virtual on the net.
Anyway, as I was saying, on those weekends we will often run an ad in the paper complete with a photo of the property and details of the property and open house dates and time.
Down in the bottom right hand corner of the ad there is a cameo shot of the listing agent. We use visual branding here in Tucson a lot.
Last Saturday afternoon Barbara had a call come in when she couldn’t take it and it went to voice mail. When we were free she checked her message and the message was from a lady that saw Barbara’s open house ad in the paper and wanted her to get back to her, but since she wasn’t answering her phone she would appreciate a call, but wouldn’t be available until late Saturday night.
Barbara returned her call and left a voice message.
Sunday, Barbara returned her call and left a voice message.
Monday, Barbara returned her call and left a voice message.
Tuesday morning the lady called Barbara and said she appreciated very much Barbara talking the time to return her call.
Her urgent need on Saturday about the ad. . . . .
She really liked the way Barbara’s hair looked in the paper and wondered where she got her hair done for that picture.
I sure like running ads in the paper and holding open houses.
Who said real estate is dull.
Have you ever done a Google search and when you clicked on a link it went to the homepage of the site and not to the information you were looking for.
Most of us take 1 millionth of a second to see it isn’t there and rather than try and find navigation to the page we click back and move on to the next search result. I wanted a way to keep them from hitting that back button and moving on.
I like the site search on our blogs and went looking for something to do the same on our web site. I found Google Site Search.
Google Site Search is a great way to let people enter their search term and this time it will only search your site. There is a good chance they won’t be so quick to click away once they see this search option. I’ve tested it on our Tucson Real Estate site and it returns the exact page reference that came up in the original search taking your visitor to the page they wanted in the first place.
Here is the process to put Google SiteSearch on your Homepage:
- Go to the Google Site Search Page
- check the agree to terms of service
- click the get code button
- Scroll down to the bottom option code window
- Reread 4. There are three sets of code, you want the bottom one.
- Copy it.
Here is the catch, yeah there always seems to be a catch doesn’t there. This code will produce 35 WC3 Errors on you homepage.
I found this on a routine check of our homepage on the WC3 validator page. It took me a few minutes to clean up the code so it would validate.
Here is the process:
- Change all CAPS to lower case ex. INPUT to input
- Make all lines of code self closing including <br> to <br />
- Put all values in quotes ex. input type=”text” NOT input type=text
A rule of thumb is after = close in quotes - remove the </form> at the end
it isn’t needed you’ve made all lines self closing - change checked to checked=”checked”
Here is the code as it should changed to validate.
<!-- SiteSearch Google -->
<form action=”http://www.google.com/search”/>
<input type=”hidden” name=”ie” value=”utf-8″/>
<input type=”hidden” name=”oe” value=”utf-8″/>
<table bgcolor=”#FFFFFF”><tr><td>
<a href=”http://www.google.com/“>
<img src=”http://www.google.com/logos/Logo_40wht.gif” border=”0″ alt=”Google”/></a></td><td>
<input type=”text” name=”q” size=”31″ maxlength=”255″ value=”"/>
<input type=”submit” name=”btnG” value=”Google Search”/><input type=”hidden” name=”domains” value=”yourdomain.com”/><br /><input type=”radio” name=”sitesearch” value=”"/> WWW <input type=”radio” name=”sitesearch” value=”yourdomain.com” checked=”checked”/>
yourdomain.com <br /></td></tr></table>
<!-- SiteSearch Google -->
You can’t copy this code from the page it won’t work.
I’m not the brightest bulb in the pack when it comes to this code in a post stuff. Here is the googlesitesearch.pdf file.
- Once it is open
- select the I bar select function
- swipe the code
- copy it.
You can now paste it into your web page, changing the three references to “yourdomain” located near the bottom of the code to . . . . . you got it, your domain.
DO NOT CHANGE names=”domain”
Once you have added and saved you can use the validator page to check for errors on your homepage.
Assuming you didn’t have any errors before adding this code. ![]()
I really like the functionality of this piece of code. It is just too bad that Google would provide a piece of code that is so obviously out of standard coding practices for today.
And if anyone can tell me how I can start putting code in a post that can simply be copied and applied. Please let me know.
Setting up the wp-configure.php file
Before you can install Wordpress you have to have a valid MYSQL database setup and you have to create the wp-configure.php file.
Here is the current place to go to get The latest version of Wordpress.
Wordpress comes with a wp-sample-configure.php file. You can open this using notepad if you don’t have a file editor for html or php files.
In the previous post Single Property Sites – Hostingwe had you write down the MYSQL database number for our example we are using 159 as the database number.
Here is what it looks like and the highlighted words are the ones you need to fill in.
// ** MySQL settings ** //
define('DB_NAME', 'mystreet'); // The name of the database
define('DB_USER', 'mystreet'); // Your MySQL username
define('DB_PASSWORD', 'listings'); // ...and password
define('DB_HOST', 'mysql159.secureserver.net'); // 99% chance you won't need to change this value// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!// Change this to localize WordPress. A corresponding MO file for the
// chosen language must be installed to wp-includes/languages.
// For example, install de.mo to wp-includes/languages and set WPLANG to 'de'
// to enable German language support.
define ('WPLANG', '');/* That's all, stop editing! Happy blogging. */define('ABSPATH', dirname(__FILE__).'/');
require_once(ABSPATH.'wp-settings.php');
?>
Once you have filled in the information for the database you just created save this file as wp-configure.php
When we set up the hosting we created a folder called “mystreet” this is where we want to upload the Wordpress files including the wp-configure.php file you just edited.
Don’t upload the wordpress folder, just the files inside the folder to the “mystreet” folder you created for the property.
Installing Wordpress
Now comes the easy part of the installation process.
Go to your browser and type in the following
“http://www.domainname.com/foldername/wp-admin/install.php”
If it is a subdomain it will be “http://subdomain/domainname.com/foldername/wp-admin/install.php”
If the configure.php file is right it will install. If not go back and check your database, username, description and password to the database. When it installs you are given the login which is always “admin” and a password to enter.
Write down the password and go ahead and login.
- Change the password
- Fill in your email address
- Change the blog description
- Save
The next thing I do is immediately delete the “about” page and “hello world” post and comment. You want to get rid of these right away before they get picked up on the web.
Here is where we are headed

It won’t be long and you can have a site up that is your time shifted 24/7 open house.
Setting up Wordpress now begins. Here are some of the things we will be covering.
- Set your category names
- Set the permalink structure
- pick a theme
- upload your plugins
- activate the plugins
For now:
- Go take some good photos of the place
- Scan the documents you want to link to
- Seller Property Disclosure Statement
- Lead based paint of if built before 1978
- Run a CMA and convert to pdf if desired
- Create a full color flyer and link to it.
- Find the places and activities of interest near the property
That’s enough for now. We will go into each of these in post to follow.
Hey, it might seem like a lot, but in just three posts you’ve learned
- why single property sites are worth the effort.
- how to purchase a domain if you need one and purchase a hosting plan.
- how to create a MYSQL database.
- how to install Wordpress.
That’s not bad for three short posts.

Have you ever heard of Ordie Tryin the Realtor? He has done a lot of marketing over the years doing his best to represent buyers and sellers in his real estate market. Ordie is one of those old ways are best kind of agent.







Comment Spam Trap – Wordpress Plugin
By Dave Smith Sunday February 25, 2007
When I first installed the plugin I set up the plugin to email me the trapped comments. I wanted to make sure it wasn’t trapping and deleting comments I wanted. It doesn’t. It is very slick in how it works, getting the spam bots to fill in a field that isn’t visible to a regular commenter.
I’m still using Askimet on all the sites. Since putting the Comment Spam Trap into place I’ve only had one comment come through.
Yes, there are still some spammers that like to do it themselves, go figure. This is where Askimet comes in to put the final death grip on the slippery human touch spam.
It is a simple concept and one I’m surprised someone hasn’t come up with before. SEOlogs.com is who we have to thank for the Comment Spam Trap Wordpress Plugin.
I think if you take it for a test spin, you won’t want to unplug this very handy plugin.