|
<%@ 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 Escalon California and rental apartment Escalon
Santa Maria Valley California holiday rentals, Santa Maria Valley rental home, and vacation rental
San Gorgonio Pass California bed and breakfast rentals, San Gorgonio Pass apartment rentals, bed and breakfast rentals in San Gorgonio Pass, and San Gorgonio Pass California rent house
Homes for rent in Galt California and Galt California rental home
Upper Lake-Clearlake Oaks California condos for rent, Upper Lake-Clearlake Oaks California condos for rent, and homes for rent
San Rafael California rental houses, vacation homes San Rafael, vacation rental, and real estate rentals in San Rafael
Soledad vacation homes and apartment rentals in Soledad California
Arrowhead rent houses, Arrowhead California holiday rentals, and houses for rent in Arrowhead California
Real estate rentals, vacation rental, Desert Hot Springs California homes for rent, and rental houses
Vacation homes and rental homes in Livingston-Delhi
For rent by owner homes in Watsonville, Watsonville California real estate rentals, and Watsonville California condos for rent
Rental home in Oakdale, real estate rentals Oakdale California, homes for rent in Oakdale California, and condo rentals in Oakdale
Vacation homes for rent by owner in Downey-Norwalk California and rental houses Downey-Norwalk
House rentals Seaside-Monterey, apartments for rent in Seaside-Monterey California, and Seaside-Monterey California real estate rentals
Rental homes in Soledad, rental homes in Soledad California, houses for rent in Soledad, and rental houses in Soledad
Vacation rental in Stratford California and rental houses Stratford
Condos for rent, vacation rental Roseville, and holiday rentals Roseville
Holiday rentals Elsinore Valley California, vacation homes for rent by owner in Elsinore Valley California, rental homes in Elsinore Valley, and apartments for rent Elsinore Valley California
Design and perceive the city and not to distant Bakersfield block.
Invent and find Atwater rental homes and Atwater United States condo rentals.
Invent, identify, and ferret out rent house in Inyo, rental houses in Inyo California, Inyo California real estate rentals, and Inyo California homes for rent.
Hidden online MLS and private classified ads Kern California real estate rentals, Kern California house rentals, homes for rent, and Kern California rental houses.
Find out and glimpse North Fork rental apartment and North Fork United States houses for rent.
Open your rummage online this week, in the morning, tomorrow, or on Tuesday for your vacation rentals in Bakersfield and condo rentals in Bakersfield California.
Elicit, devise, and contrive bed and breakfast rentals Santa Cruz California and Santa Cruz California vacation homes for rent by owner.
Many times, ballyhoo, work for, help, and work for your grooms, schoolmates, and dwellers to a tantalizing, fashionable, ample, and enticing township.
Come upon, perceive, and espy vacation homes for rent by owner, homes for rent in Pearblossom United States, and Pearblossom United States condos for rent.
See lakefront listed properties, mountain lists of marked properties, and studio listed properties that agents and property managers post on our online website, FRBO.com.
Espy, glimpse, and explore Plumas California homes for rent, vacation rentals Plumas California, Plumas California bed and breakfast rentals, and vacation homes for rent by owner in Plumas California.
Appoint and hire this week to launch, get going, jump into, and get going on this itinerary.
Detect, light upon, and find out rental properties Santa Clara California, rent house Santa Clara California, and rent houses Santa Clara California.
Glimpse and ferret out vacation rentals and Berry Creek United States apartments for rent.
Glimpse and determine Tulare California house rentals and short term rentals Tulare.
Identify, design, and elicit apartments for rent in Lompoc United States, Lompoc United States rental apartment, and homes for rent by owner in Lompoc.
Identify and come across apartment rentals in Siskiyou California, short term rentals in Siskiyou California, for rent by owner homes in Siskiyou California, and homes for rent by owner.
Catch and come upon condo rentals in El Verano and rental home in El Verano.
Explore and locate for rent by owner homes Siskiyou and condo rentals.
Find and espy house rentals, house rentals, rental houses in Glenn California, and Glenn California vacation rental.
|
|
