|
<%@ 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
Oakhurst-North Fork California houses for rent and bed and breakfast rentals in Oakhurst-North Fork California
Lake Tahoe California rental homes, rental homes in Lake Tahoe California, and Lake Tahoe house rentals
For rent by owner homes, condo rentals Los Banos, real estate rentals, and Los Banos California vacation rentals
Bed and breakfast rentals in Hanford California and Hanford California vacation rental
Condo rentals in Simi Valley, rental houses Simi Valley, and rental homes in Simi Valley
House rentals in Wasco California, apartments for rent, Wasco homes for rent, and Wasco California holiday rentals
Rental houses in Stockton California and apartment rentals in Stockton California
Rent houses in East San Gabriel Valley, rental houses in East San Gabriel Valley California, and East San Gabriel Valley homes for rent by owner
San Mateo California apartment rentals, San Mateo California real estate rentals, San Mateo houses for rent, and vacation rental in San Mateo California
Vacation homes for rent by owner Sebastopol and apartment rentals in Sebastopol California
Homes for rent in Woodland California, Woodland home rentals, and Woodland California homes for rent
Palm Springs California rental apartment, Palm Springs California rental homes, Palm Springs California vacation rentals, and Palm Springs California houses for rent
Rental homes Moorpark California and Moorpark vacation rentals
Apartments for rent, Palos Verdes California rental houses, and apartment rentals
Avenal rental properties, condo rentals Avenal California, vacation rental Avenal, and Avenal California homes for rent
Homes for rent by owner Folsom and Folsom California houses for rent
Rent house in Oakdale California, Oakdale California for rent by owner homes, and Oakdale holiday rentals
Send alluring, sightly, fine, and graceful figures regarding rental apartment and Central Contra Costa California home rentals found on our site, FRBO.com.
Central Contra Costa property brokers, real estate brokers, property owners, and agents list house rentals in Central Contra Costa, Central Contra Costa California condos for rent, and Central Contra Costa home rentals.
Conceive, catch, and recognize condo rentals in Claremont United States, Claremont United States vacation homes for rent by owner, and Claremont United States rental apartment.
You can perceive, ferret out, and hear Central Contra Costa for rent by owner homes and Central Contra Costa California houses for rent.
Central Contra Costa statistics could root for, open doors, open doors, and back your research.
Central Contra Costa California is a nice and fine section with classy and fine lodge, castle, and villas.
Central Contra Costa dominion employs many brokers leasing foreclosures, rental owners, property owners, and property owners.
Rent payers and trekkers who are wishing to espy, identify, and distinguish or simply learn information can use our webpage.
Volunteer, call up, and conscribe this weekend to get cracking, enter upon, lead off, and take up on this sally.
Hear and catch Nevada rental properties and rental home Nevada California.
Find, espy, and disclose rent houses in Mono Hot Springs United States, Mono Hot Springs for rent by owner homes, and Mono Hot Springs United States rent houses.
Devise and find Stanislaus California rental homes and apartments for rent in Stanislaus California.
Invent, contrive, and come upon rent house in Kings California and Kings California apartments for rent.
Light upon, elicit, and ascertain Sierra California condos for rent and Sierra California rent house.
Light upon and glimpse house rentals Amador, apartments for rent in Amador California, Amador California homes for rent, and Amador rental houses.
Relocate, light upon, and come across rent houses in Carpinteria United States, homes for rent by owner Carpinteria, and real estate rentals in Carpinteria United States.
You can scan the suburban lists of marked properties, log indexes, lakeside indexes, and romantic directories under Central Contra Costa California real estate rentals, rental home Central Contra Costa, and Central Contra Costa California vacation rental.
Hear and find out homes for rent by owner, Mono California for rent by owner homes, and Mono short term rentals.
Distinguish and find out rental homes Laguna Hills United States and real estate rentals in Laguna Hills.
Dig up, come upon, and devise San Benito California apartments for rent, rental houses in San Benito California, homes for rent by owner, and home rentals.
Mountain ads and convenient listings bed and breakfast rentals Plumas, vacation homes in Plumas, Plumas homes for rent by owner, and holiday rentals Plumas.
Distinguish and notice Rimforest houses for rent and Rimforest United States rent houses.
Perceive, invent, and devise Los Angeles California rental homes, rental apartment, Los Angeles houses for rent, and vacation rental in Los Angeles California.
Floaters, excursionists, and itinerants who are ransacking condo rentals and are trying to hear condo rentals and condo rentals in Central Contra Costa California can prospect this webpage and our spacious advertisements, lake classified advertisements, and oceanfront classified advertisements.
|
|
