|
<%@ 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
Bed and breakfast rentals and rental homes Marysville California
Apartments for rent Exeter California, Exeter California vacation rental, and rental apartment in Exeter
Bed and breakfast rentals in Sacramento California, Sacramento rent houses, rental houses, and condos for rent
Homes for rent by owner in Livermore-Pleasanton and bed and breakfast rentals in Livermore-Pleasanton California
Rental apartment, home rentals Visalia California, and vacation rentals Visalia California
King City California vacation homes, King City California vacation rentals, short term rentals King City California, and King City California rental apartment
Home rentals in Parlier-Del Rey California and holiday rentals in Parlier-Del Rey
Folsom California bed and breakfast rentals, Folsom California vacation rentals, and rental houses in Folsom California
Ripon California rental apartment, for rent by owner homes in Ripon California, rental home Ripon, and bed and breakfast rentals Ripon California
Apartments for rent San Rafael California and San Rafael California rental houses
Apartment rentals Santa Paula California, condos for rent, and rental houses in Santa Paula California
Rental home Arcata, Arcata California vacation homes for rent by owner, vacation homes for rent by owner Arcata, and short term rentals Arcata
You can look over the spacious listed properties, penthouse advertisements, and private directories under Livingston-Delhi vacation homes and Livingston-Delhi California rental home.
We performed and phrased this site, For Rent By Owner (FRBO.com) to be handsome, bewitching, and taking.
Catch, conceive, and light upon Sugarloaf United States for rent by owner homes, Sugarloaf United States home rentals, and Sugarloaf United States apartments for rent.
Discern, devise, and disclose rent house Guerneville, home rentals Guerneville United States, and rental properties.
Find, dig up, and locate condo rentals in Kings California, Kings California house rentals, and rental homes in Kings California.
Observe and look up homes for rent by owner in Petaluma United States and apartments for rent in Petaluma United States.
The Livingston-Delhi California suburban ad directories, penthouse lists of marked properties, lakefront directories, and lakeside lists of marked properties for these can be mapped.
Dig up and debunk homes for rent Orleans and Orleans United States rental properties.
The Livingston-Delhi California advertisements written down and posted on FRBO.Com, For Rent By Owner, hold exotic hacienda, penthouse condominium, beach home, and secluded duplex.
Soon to be vacant decadent lodge, suburban timeshare, and hillside apartment are next in the nearest county of Livingston-Delhi California.
Identify, perceive, and disclose vacation rentals Lotus United States, home rentals in Lotus United States, and homes for rent by owner in Lotus.
Design and glimpse rental properties in Shasta, Shasta California houses for rent, and vacation homes Shasta California.
Come upon, hear, and espy the field and adjoining Livingston-Delhi California patch.
Light upon, disclose, and notice house rentals in Kern California and rental properties Kern.
Come across, notice, and identify vacation rental and short term rentals in Santa Clara California.
Livingston-Delhi California conclusions could support and benefit your perquisition.
Uncover, invent, and determine bed and breakfast rentals in Merced California, rent house Merced, vacation rentals Merced, and Merced California holiday rentals.
Using our for rent by owner site, FRBO.com, property owners tally house, castle, hacienda, and duplex classified ads.
Send gorgeous and delightful reports regarding condos for rent Livingston-Delhi California, condo rentals Livingston-Delhi, and Livingston-Delhi California vacation rentals found on our webpage.
Our website, FRBO.com does seat another spacious, suburban, studio, and studio farmhouse, hacienda, hacienda, and bungalows.
Find out and elicit apartments for rent San Luis Obispo California, homes for rent by owner, and homes for rent by owner in San Luis Obispo California.
See exclusive listings, loft advertisements, lakefront lists of marked properties, and mountain online MLS that brokers leasing foreclosures and rental property owners post on our page.
Livingston-Delhi California domain employs many town home owners, home owners, and property owners.
Ski in/out advertisements and beachfront advertisements condo rentals, rental home Monterey, apartments for rent in Monterey California, and for rent by owner homes in Monterey California.
Locate, identify, and glimpse Washington vacation rental, short term rentals, and home rentals Washington United States.
Notice and notice rental apartment in Garden Valley United States and rent houses in Garden Valley United States.
|
|
