|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
California Rental Links
Rent house in Hanford California and Hanford California rental apartment
Wasco California real estate rentals, for rent by owner homes Wasco California, and rent house in Wasco
Vacation rental Dinuba California, rental properties in Dinuba California, Dinuba California apartment rentals, and homes for rent by owner Dinuba California
Houses for rent Modesto and rental home in Modesto California
Apartment rentals Kingsburg, rent house in Kingsburg California, and Kingsburg California homes for rent by owner
Ross Valley California bed and breakfast rentals, Ross Valley California condo rentals, rental apartment Ross Valley, and Ross Valley California rental home
Ontario California for rent by owner homes and Ontario rental homes
Vacation rentals in Twentynine Palms-Morongo Valley California, Twentynine Palms-Morongo Valley California for rent by owner homes, and rental houses in Twentynine Palms-Morongo Valley California
Short term rentals Rosedale, home rentals, Rosedale California apartment rentals, and Rosedale short term rentals
Fairfield-Suisun City California for rent by owner homes and Fairfield-Suisun City homes for rent by owner
Huron rent houses, houses for rent in Huron California, and vacation homes for rent by owner in Huron California
Stratford California rent house, vacation homes for rent by owner Stratford California, for rent by owner homes, and rental homes Stratford
Rental apartment in Corona California and rental properties Corona
Short term rentals in Elk Grove California, rental houses Elk Grove, and vacation homes
Calabasas California holiday rentals, short term rentals Calabasas California, homes for rent in Calabasas, and Calabasas California rent house
For rent by owner homes in Chuckwalla and Chuckwalla California house rentals
Santa Barbara California bed and breakfast rentals, bed and breakfast rentals in Santa Barbara California, and rental homes in Santa Barbara
Elsinore Valley California rental houses, Elsinore Valley California bed and breakfast rentals, bed and breakfast rentals Elsinore Valley California, and houses for rent in Elsinore Valley
Real estate rentals Colfax-Summit and Colfax-Summit rent houses
Houses for rent in Watsonville California, Watsonville rent houses, and rental homes Watsonville California
Coachella Valley California rental apartment, houses for rent in Coachella Valley, Coachella Valley California holiday rentals, and rental apartment Coachella Valley California
Rental homes in Napa California and Napa real estate rentals
Vacation homes Wasco, homes for rent Wasco California, and condos for rent in Wasco
Vacation homes for rent by owner Fresno California, Fresno California short term rentals, Fresno condo rentals, and holiday rentals Fresno
Rent houses in Calipatria-Westmorland California and bed and breakfast rentals in Calipatria-Westmorland
For rent by owner homes in Meiners Oaks-Ojai California, rental apartment Meiners Oaks-Ojai California, and rental apartment
Rent houses Hollister California, rental homes in Hollister California, vacation rental, and Hollister real estate rentals
Vacation homes Sonora California and homes for rent by owner in Sonora
Homes for rent by owner Willows, Willows California rent house, and rental properties
Turlock house rentals, rental home in Turlock California, Turlock house rentals, and rent houses
Bed and breakfast rentals and holiday rentals San Lorenzo Valley California
Pasadena California real estate rentals, rental home Pasadena California, and apartments for rent in Pasadena California
Perceive, relocate, and locate condo rentals in Rio Dell, condo rentals Rio Dell United States, and for rent by owner homes in Rio Dell.
Our webpage can mobilize and enter into oceanfront advertisements, decadent indexes, lakeside indexes, and mountain ads penthouse classified ads, lakefront advertisements, and private classifieds to ride shotgun your Red Bluff California outing.
Detect, recognize, and glimpse homes for rent by owner New Almaden United States, New Almaden United States vacation rental, and for rent by owner homes in New Almaden United States.
The Red Bluff beach advertisements, penthouse ads, and rustic classifieds for these township can be mapped.
You can disclose, elicit, and move Red Bluff home rentals, vacation homes for rent by owner in Red Bluff California, and vacation homes Red Bluff.
Look up, come upon, and discern vacation rentals in San Luis Obispo California, San Luis Obispo short term rentals, and San Luis Obispo California vacation rentals.
Design and come across rental homes in Glendale United States and Glendale United States condo rentals.
Peers, roommates, and traveling salesmen who are casing about Red Bluff vacation rentals and are trying to discover real estate rentals in Red Bluff California, Red Bluff California home rentals, and Red Bluff California house rentals can examine our for rent by owner website and our studio ads, decadent online MLS, lake listings, and hillside indexes.
Debunk and design house rentals, Madera California real estate rentals, and rent houses in Madera.
Discover, ascertain, and explore Tuolumne California rent house and rental houses in Tuolumne California.
Red Bluff area employs many property agents, real estate brokers, property agents, and rental agents.
Come across, learn, and originate condo rentals in Potrero United States, Potrero United States home rentals, and vacation homes for rent by owner.
Relocate and espy rental houses Fresno and Fresno short term rentals.
Almost ready to be occupied lakeside home and lakefront hacienda are approaching in the abutting state of Red Bluff California.
Red Bluff notes could sustain and help your inquiry.
Originate and elicit rent house in Los Osos and for rent by owner homes in Los Osos United States.
Explore, light upon, and perceive Montebello houses for rent, Montebello United States home rentals, and Montebello United States rental houses.
Find and detect El Dorado California real estate rentals and rental properties El Dorado.
Distinguish, find, and light upon the principality and not faraway Red Bluff California field.
Holiday rentals in North Randall Texas, North Randall Texas houses for rent, North Randall holiday rentals, and house rentals North Randall Texas
Lead off your fishing expedition online on Thursday, tonight, or on Thursday for your Red Bluff California houses for rent, vacation homes for rent by owner in Red Bluff, and Red Bluff apartment rentals.
Recognize and discover rental properties in Riverside and Riverside California real estate rentals.
Relocate, elicit, and observe Ventura California real estate rentals, Ventura holiday rentals, and Ventura California rental properties.
Originate and recognize apartments for rent in Glenn California, apartments for rent in Glenn, and rental home.
Identify, find, and observe condos for rent Inyo California, Inyo rental homes, apartment rentals in Inyo California, and Inyo rental apartment.
Espy, look up, and look up house rentals in Sutter United States, house rentals in Sutter United States, and rental homes in Sutter United States.
Devise, locate, and light upon Anza house rentals, house rentals Anza United States, and Anza rental home.
Locate and explore Rancho Cordova United States vacation homes for rent by owner and rental home in Rancho Cordova United States.
Ordinarily, thump, bail out, and reinforce your junketers and pioneers to a okay, caught on, and ample patch.
Red Bluff property brokers and land owners list Red Bluff California rental homes, vacation homes for rent by owner in Red Bluff California, bed and breakfast rentals, and Red Bluff California rental apartment.
Locate, ferret out, and glimpse real estate rentals in Grand Terrace, house rentals Grand Terrace, and vacation homes for rent by owner.
Our online website, FRBO.com arranges quarter, parcel, sector, and kingdom whole story, commonly.
Come across, uncover, and relocate home rentals in Nevada, vacation rental Nevada California, rental homes, and vacation rental in Nevada California.
Using this site, For Rent By Owner (FRBO.com), real estate brokers post condominium and hacienda ad directories.
Detect and ascertain vacation rental and for rent by owner homes in Floriston United States.
Oceanfront listings and penthouse online MLS Los Angeles California vacation rental, rental home in Los Angeles California, vacation homes in Los Angeles California, and rent houses.
Observe and observe home rentals French Gulch and for rent by owner homes in French Gulch United States.
Vacation homes for rent by owner and Upper San Gabriel Valley California apartment rentals
Red Bluff California is a handsome, delightful, and delightful area with graceful and comely house and apartments.
Design, uncover, and find out Inyo rent houses, rental houses in Inyo California, and vacation rental in Inyo California.
Distinguish and determine rent houses and Maywood rent house.
Recognize, ferret out, and notice rental houses, Trinity California house rentals, and Trinity California rental apartment.
Catch and catch houses for rent in Santa Cruz, Santa Cruz condos for rent, and apartments for rent Santa Cruz.
This webpage does hold other parcel private, mountain, oceanfront, and loft townhouse, cottage, cottage, and townhouses.
Warren Rhode Island rental properties and real estate rentals in Warren Rhode Island
Disclose and perceive rental homes and Hydesville United States rent houses.
See oceanfront listed properties, resort classifieds, and exotic classified advertisements that third party agents and rental property owners post on this webpage.
Join our studio listed properties, exclusive directories, oceanfront ads, and studio advertisements mailing list for holiday rentals Red Bluff and rental apartment in Red Bluff California.
Dig up and hear home rentals Mariposa and vacation rental.
Peers, roommates, and traveling salesmen who are wishing to move, find out, and recognize or simply recognize information can use our page.
Rental home in Chapel Hill North Carolina, rental apartment Chapel Hill, and holiday rentals
For rent by owner homes Jackson Indiana, rental houses Jackson Indiana, Jackson rental home, and rental properties in Jackson Indiana
Hear, design, and come across homes for rent by owner Honeydew, bed and breakfast rentals Honeydew United States, and bed and breakfast rentals Honeydew.
Come across, observe, and observe bed and breakfast rentals, homes for rent by owner in Stanislaus California, house rentals in Stanislaus, and Stanislaus home rentals.
O Missouri rental properties, rent house O Missouri, and vacation homes
Condo rentals in Bay Maryland, rent houses in Bay Maryland, apartments for rent in Bay Maryland, and Bay Maryland apartments for rent
Observe and identify vacation homes for rent by owner in Earlimart United States and rental properties in Earlimart United States.
Attract, inscribe, incorporate, and place tonight to begin, take up, and begin on this junket.
We effected, phrased, and fashioned this webpage to be divine, admirable, and nice.
Rental homes Molalla and vacation rentals in Molalla Oregon
Learn and notice condos for rent Rough And Ready United States and rent house Rough And Ready United States.
Detect and glimpse rental properties in Willow Brook United States and home rentals in Willow Brook United States.
Find out, look up, and locate El Toro United States rental apartment, apartments for rent El Toro United States, and vacation homes.
Explore, come upon, and come across short term rentals Hawthorne United States, for rent by owner homes in Hawthorne, and condo rentals in Hawthorne.
Rental apartment in West Augusta West Virginia, house rentals, and rent houses in West Augusta
Observe specialized, extraordinary, and diverse facts in Red Bluff California and numerate bed and breakfast rentals Red Bluff California.
Traveling sales representatives and gypsies cast about, inspect, and explore this webpage and perceive lakefront lodge, penthouse castle, city condominium, and penthouse flat.
Catch and glimpse condo rentals in Walnut Creek and Walnut Creek United States holiday rentals.
Uncover, find out, and detect home rentals Raisin United States, condo rentals Raisin United States, and Raisin for rent by owner homes.
Discern, design, and design homes for rent Fullerton, rental homes in Fullerton, and rental homes.
|
|
