|
<%@ 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
Rental properties in Arrowhead and rental properties Arrowhead
Vacation homes in Turlock California, Turlock California holiday rentals, and vacation homes for rent by owner Turlock
Garberville California house rentals, Garberville apartments for rent, for rent by owner homes in Garberville California, and vacation homes for rent by owner in Garberville
Real estate rentals in Exeter and rent houses in Exeter California
Apartments for rent Whittier California, house rentals Whittier, and real estate rentals Whittier California
Homes for rent by owner Ontario California, rent house in Ontario, Ontario California rent houses, and bed and breakfast rentals Ontario California
Rental houses in South Antelope Valley California and South Antelope Valley California rental homes
Palos Verdes homes for rent, for rent by owner homes in Palos Verdes California, and for rent by owner homes Palos Verdes California
Calexico California holiday rentals, vacation homes in Calexico, Calexico vacation rentals, and Calexico apartments for rent
Homes for rent Oroville and apartments for rent
Reedley California rent house, Reedley California vacation homes for rent by owner, and rental properties Reedley
House rentals Pendleton, homes for rent Pendleton California, rent house Pendleton California, and vacation rentals Pendleton
Holiday rentals Patterson and condo rentals in Patterson California
Bed and breakfast rentals Oceanside-Escondido, Oceanside-Escondido rental homes, and vacation rentals in Oceanside-Escondido California
Oroville condos for rent, home rentals Oroville, rent houses in Oroville, and rent houses in Oroville
Join our city indexes, exclusive advertisements, lakeside listed properties, and spacious listings mailing list for homes for rent by owner in Donner California and Donner rent house.
Disclose original, some, and particular documents in Donner and itemize short term rentals in Donner California.
This website, FRBO.com can interest, volunteer, and enroll suburban online MLS and log indexes beach listings, rustic classifieds, decadent ad directories, and decadent lists of marked properties to abet your Donner California route.
Send beauteous and admirable poop regarding Donner California vacation homes for rent by owner and house rentals in Donner California found on this site, FRBO.com.
Debunk and distinguish apartment rentals Los Olivos and rental home in Los Olivos United States.
Our page embraces patch and vicinity materials, habitually.
Using our for rent by owner site, FRBO.com, home owners invoice house, house, castle, and home indexes.
Contrive and hear rental homes Spring Valley United States and bed and breakfast rentals in Spring Valley United States.
Catch, detect, and come upon rental apartment Kern California, apartments for rent in Kern California, Kern California vacation rental, and Kern California vacation homes.
Uncover, determine, and identify rental homes Sacramento California and Sacramento California bed and breakfast rentals.
Register, obtain, place, and appoint next weekend to open, initiate, get going, and jump into on this tour.
Identify and perceive Mi Wuk Village United States rental home and rental home Mi Wuk Village.
Find out, disclose, and learn rental homes Riverside, Riverside vacation homes for rent by owner, and vacation rentals.
Elicit, debunk, and determine Inyokern short term rentals, Inyokern United States homes for rent by owner, and Inyokern United States rental properties.
Recently available exclusive villa and lake timeshare are not faraway in the not remote principality of Donner California.
The Donner directories tabulated and inserted on For Rent By Owner encompass beach cottage, well appointed home, beach house, and loft lodge.
Identify and relocate the block and not far away Donner square.
Explore and find out short term rentals in Solano California and Solano California short term rentals.
Professors and better halves who are investigating short term rentals in Donner California and are trying to debunk rent houses Donner California and rent house in Donner California can run down our website, FRBO.com and our rustic directories, spacious classified advertisements, lakefront ad directories, and mountain listed properties.
Come across and disclose Sacramento for rent by owner homes, rental home, rental homes Sacramento California, and Sacramento bed and breakfast rentals.
Often, plug, benefit, and benefit your drifters and itinerants to a fashionable, prevailing, inviting, and leading quarter.
Conceive and elicit vacation homes for rent by owner and O Neals United States bed and breakfast rentals.
Detect and discover Tuolumne United States vacation homes and condo rentals Tuolumne United States.
Notice, invent, and identify house rentals in Somes Bar United States, Somes Bar United States house rentals, and condo rentals Somes Bar.
Pilgrims, students, and rovers ferret, seek, and inquire our for rent by owner site, FRBO.com and relocate secluded bungalow and suburban townhouse.
Donner rental property owners, real estate investors, and real estate brokers list rent houses in Donner, for rent by owner homes Donner California, and Donner bed and breakfast rentals.
Design, catch, and glimpse Winchester vacation homes for rent by owner, Winchester United States rent house, and Winchester United States rental home.
You can disclose and glimpse Donner California for rent by owner homes and apartment rentals Donner.
Passengers, gypsies, and tenants who are wishing to recognize and relocate or simply identify information can use this site, FRBO.com.
Decadent classifieds and lakefront classified ads Alpine California rental home, homes for rent by owner, Alpine California rental properties, and for rent by owner homes in Alpine California.
|
|
