REAL-ESTATE-LISTINGS.PHP

I wrote this for a web hosting client who was in the real-estate business. It allows you to put listings up for sale and for rent. Installing this script requires some knowledge of PHP and MySQL. Don't forget to create the necessary tables and to edit db_username_password.php, so that the variables contained reflect the setup you have on your web server or web hosting account.

real-estate-listings.zip

create table homes
(
id int primary key AUTO_INCREMENT,
type_e tinytext,
type_f tinytext,
short_description_e tinytext,
short_description_f tinytext,
description_e text,
description_f text,
location_e tinytext,
location_f tinytext,
address_e tinytext,
address_f tinytext,
postal_code tinytext
)

create table market
(
id int primary key AUTO_INCREMENT,
home_id int not null,
date_posted date,
date_available date,
rented tinyint not null,
sold tinyint not null,
price float(255, 2) unsigned,
rent_furnished float(255, 2) unsigned,
rent_unfurnished float(255, 2) unsigned,
condo_fees float(255, 2) unsigned,
municipal_taxes float(255, 2) unsigned,
school_taxes float(255, 2) unsigned
)

create table images
(
id int primary key AUTO_INCREMENT,
home_id int not null,
description_e tinytext,
description_f tinytext
)