|
<%@ 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
Apartments for rent in Coachella Valley California and vacation homes Coachella Valley California
Rental home in Chico California, vacation homes for rent by owner in Chico California, and Chico California rent house
Tehachapi real estate rentals, Tehachapi rental apartment, vacation homes for rent by owner in Tehachapi California, and Tehachapi California vacation rentals
Rental home Northeast Marin California and holiday rentals in Northeast Marin
Condos for rent South Bay Cities California, South Bay Cities real estate rentals, and home rentals South Bay Cities California
Rental houses in Pajaro California, real estate rentals in Pajaro California, rental homes Pajaro California, and Pajaro California real estate rentals
Mono South rental properties and apartments for rent in Mono South California
Toro rental houses, Toro California real estate rentals, and vacation rental
Orosi-Cutler California bed and breakfast rentals, house rentals Orosi-Cutler California, homes for rent by owner Orosi-Cutler California, and holiday rentals
Vacation rentals in Palo Verde California and Palo Verde California vacation rental
Rental home in Lompoc Valley, short term rentals in Lompoc Valley California, and Lompoc Valley vacation rental
Rent houses King City California, King City California homes for rent by owner, vacation rental, and King City California house rentals
Short term rentals in Lake Isabella and Lake Isabella California vacation homes
Homes for rent by owner in North El Dorado California, North El Dorado California bed and breakfast rentals, and North El Dorado California vacation rentals
Home rentals Tulare, rent houses in Tulare California, rental homes in Tulare, and holiday rentals Tulare California
Rental apartment in Long Beach-Lakewood and vacation rentals in Long Beach-Lakewood
Home rentals in Corona California, Corona vacation rentals, and house rentals
Lompoc Valley apartment rentals, vacation homes Lompoc Valley California, rental apartment in Lompoc Valley California, and Lompoc Valley California rent house
For rent by owner homes and condos for rent
Vacation rentals, Marysville condo rentals, and homes for rent Marysville California
Invent, relocate, and conceive holiday rentals Hacienda Heights, bed and breakfast rentals Hacienda Heights, and rental homes Hacienda Heights United States.
Discover, ferret out, and espy Penryn short term rentals, rental houses Penryn, and Penryn rental houses.
Contrive and find house rentals in Le Grand and rental houses in Le Grand.
Hear, uncover, and ascertain the block and proximate Livermore-Pleasanton California county.
You can disclose, perceive, and glimpse rental homes Livermore-Pleasanton and Livermore-Pleasanton California for rent by owner homes.
Traveling women and fortune-hunters who are wishing to come across and explore or simply uncover information can use this website, FRBO.com.
Send good-looking and ideal goods regarding homes for rent and homes for rent by owner in Livermore-Pleasanton California found on this site, FRBO.com.
Livermore-Pleasanton land owners, town home owners, property managers, and rental agents list apartment rentals and Livermore-Pleasanton vacation homes.
Livermore-Pleasanton dominion employs many real estate agents, property owners, land owners, and landlords.
Contrive and catch vacation homes for rent by owner and house rentals Universal City United States.
Our online website, FRBO.com does involve special loft, suburban, suburban, and beach cottage, cabin, lodge, and duplexs.
Invent and explore rental apartment in Planada United States and rent house in Planada United States.
Espy, disclose, and disclose rent houses in Del Norte California and vacation rental in Del Norte California.
Discover, find out, and explore vacation homes Ryde United States, Ryde United States vacation rentals, and Ryde homes for rent by owner.
Livermore-Pleasanton California is a lovely and appealing stretch with exquisite and ideal house, lodge, castle, and duplexs.
Move and distinguish Nevada California rent house and rental houses in Nevada.
Fraternity members and sorority sisters cast about, frisk, and scour this webpage and glimpse beach flat and hidden flat.
Notice and contrive rental houses in Fresno, condos for rent, and short term rentals in Fresno California.
Observe and devise Solano California vacation homes for rent by owner and Solano California rental properties.
Learn, identify, and light upon vacation rental Monterey California, rental apartment in Monterey California, and for rent by owner homes.
Induct, inscribe, list, and list next weekend to get going, originate, take up, and jump into on this odyssey.
Perceive, originate, and locate house rentals in Downey United States, Downey United States holiday rentals, and Downey rental homes.
Conceive, disclose, and look up Modoc California short term rentals, Modoc California short term rentals, holiday rentals in Modoc, and home rentals Modoc California.
The Livermore-Pleasanton ski in/out listings and decadent lists of marked properties for these plot can be mapped.
Ready to move in beach ranch and waterfront townhouse are abutting in the contiguous block of Livermore-Pleasanton California.
The Livermore-Pleasanton California classified advertisements pegged and tabulated on our for rent by owner site, FRBO.com hold convenient farmhouse, lakeside farmhouse, beach houseboat, and loft home.
Ascertain and debunk rent house Upper Lake United States and short term rentals Upper Lake.
Move and identify short term rentals in Big Pine United States and vacation homes in Big Pine.
Elicit and debunk Santa Cruz California homes for rent and rental properties.
Elicit, relocate, and find out vacation homes for rent by owner Plumas California, holiday rentals Plumas, and bed and breakfast rentals in Plumas.
|
|
