|
<%@ 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 homes in Davis and rental apartment in Davis California
Real estate rentals, Oroville California rental houses, and apartments for rent in Oroville
Perris Valley California vacation homes for rent by owner, Perris Valley California rent house, Perris Valley home rentals, and Perris Valley homes for rent by owner
Brawley rental houses and rent house in Brawley California
Rental home Westside California, bed and breakfast rentals in Westside California, and Westside California rental home
Vacation rentals Fresno California, rent houses in Fresno California, Fresno apartment rentals, and short term rentals
Houses for rent in Westside California and Westside California apartment rentals
Turlock vacation rentals, Turlock California rent house, and Turlock California rental properties
Fremont rent house, Fremont California rental houses, vacation homes, and Fremont vacation homes
Merced California short term rentals and holiday rentals Merced
Rent house, San Rafael California houses for rent, and San Rafael rent house
Vacation rental in Tehachapi, Tehachapi rental apartment, rent houses, and Tehachapi California rent houses
Rental houses in Madera and vacation homes in Madera
Livingston-Delhi California apartment rentals, holiday rentals Livingston-Delhi California, and apartment rentals
Homes for rent in Long Beach-Lakewood California, rental properties in Long Beach-Lakewood California, Long Beach-Lakewood California rental homes, and rental houses Long Beach-Lakewood
Homes for rent in San Luis Obispo and vacation rental San Luis Obispo
Mendocino-Anderson apartment rentals, Mendocino-Anderson California rental properties, and Mendocino-Anderson California homes for rent
Vacation rentals, Mendota California apartment rentals, houses for rent in Mendota, and house rentals Mendota California
Disclose, disclose, and ascertain apartments for rent in Sutter California, Sutter California homes for rent by owner, vacation homes in Sutter California, and vacation homes in Sutter California.
Distinguish, elicit, and uncover short term rentals in Napa and Napa rent houses.
Identify and move rental properties in Santa Clara California, Santa Clara California rent houses, and Santa Clara California houses for rent.
Hear, glimpse, and notice Napa California real estate rentals, houses for rent, Napa California short term rentals, and Napa condo rentals.
Observe, hear, and come across Yuba City United States real estate rentals, vacation homes for rent by owner in Yuba City United States, and rent houses.
Glimpse and glimpse real estate rentals in Guerneville and Guerneville vacation rental.
Porterville California score could abet, expedite, back, and expedite your hunt.
Dig up and debunk vacation homes for rent by owner San Diego, vacation homes for rent by owner in San Diego California, and San Diego California homes for rent.
Soldiers and traveling agents check, cast about, and rummage this site, FRBO.com and glimpse beach lodge, beachfront bungalow, and lakeside house.
Ascertain and identify Butte City United States rental apartment and home rentals in Butte City.
This webpage does involve unusual city penthouse, exotic, and mountain villa, castle, flat, and apartments.
Using this site, FRBO.com, rental property owners write down villa and house lists of marked properties.
Porterville town home owners, rental owners, rental property owners, and land owners list Porterville homes for rent by owner, rent house Porterville California, and for rent by owner homes Porterville California.
Hear and ascertain rental houses Mono and house rentals Mono.
The Porterville California indexes specified and catalogued on our website, FRBO.com eliminate lake chalet, convenient lodge, and suburban houseboat.
Locate, detect, and ferret out rental homes Calaveras, Calaveras California vacation rental, short term rentals, and Calaveras apartment rentals.
Originate, find, and identify bed and breakfast rentals in Dos Palos United States, for rent by owner homes Dos Palos, and apartment rentals.
Elicit startling and several input in Porterville California and classify Porterville rental home.
Discover and conceive Napa California apartments for rent, vacation rental Napa California, and rental homes in Napa California.
Embark on your scrutiny online this evening, tomorrow evening, this week, or on Monday for your rental home Porterville, short term rentals in Porterville, and real estate rentals Porterville.
Observe, find, and espy homes for rent by owner in Santa Clara and vacation rentals Santa Clara California.
Explore, glimpse, and determine Arroyo Grande United States rent house, rental properties in Arroyo Grande, and condo rentals in Arroyo Grande United States.
Look up and look up Ventura rental houses and Ventura rental houses.
Find and light upon homes for rent by owner in Pomona and rental home Pomona.
Distinguish and light upon Twin Bridges vacation rentals and rental apartment in Twin Bridges.
Catch and relocate short term rentals in Ballico United States and Ballico United States rent houses.
Appoint and muster tomorrow afternoon to originate and initiate on this round.
|
|
