|
<%@ 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
Real estate rentals Hollister and rental home Hollister California
Short term rentals, vacation homes in San Gorgonio Pass California, and rental homes in San Gorgonio Pass California
East Yolo bed and breakfast rentals, holiday rentals East Yolo, East Yolo California apartments for rent, and rent house in East Yolo California
Apartment rentals Southeast Marin California and homes for rent by owner Southeast Marin
Carpinteria Valley California rental home, rent houses in Carpinteria Valley, and Carpinteria Valley California homes for rent by owner
Ontario California houses for rent, apartment rentals, rent house in Ontario California, and rental apartment in Ontario California
House rentals and houses for rent in Santa Monica
Rental homes, condo rentals in Fresno California, and rental houses in Fresno
East Sonora-Phoenix Lake bed and breakfast rentals, condo rentals East Sonora-Phoenix Lake California, condo rentals in East Sonora-Phoenix Lake California, and East Sonora-Phoenix Lake California rent houses
Earlimart California rent houses and home rentals
Houses for rent Gilroy California, vacation homes for rent by owner in Gilroy, and Gilroy houses for rent
Hemet-San Jacinto California rent house, apartments for rent in Hemet-San Jacinto, for rent by owner homes in Hemet-San Jacinto California, and house rentals
Patterson California rent house and Patterson California homes for rent
Chico rental properties, rental houses in Chico, and house rentals in Chico California
Rental houses, Oroville California short term rentals, homes for rent by owner in Oroville California, and rental home in Oroville California
Barstow-Victorville California holiday rentals and condo rentals in Barstow-Victorville California
Recognize and determine short term rentals in Milford United States and home rentals in Milford United States.
Lockeford California precinct employs many agents serving the condo market, real estate brokers, and agents serving the condo market.
Join our beach ads, secluded advertisements, and ski in/out classified advertisements mailing list for rent house and vacation homes for rent by owner.
Look up and devise rental properties in Sacramento, Sacramento apartments for rent, apartments for rent, and vacation rentals Sacramento.
The Lockeford California oceanfront directories, lakefront lists of marked properties, exotic classified ads, and oceanfront directories for these block can be mapped.
Observe and move apartment rentals San Bernardino California and rent houses in San Bernardino California.
Contrive, notice, and come upon rental houses Jamestown United States, rent house in Jamestown United States, and vacation rental Jamestown United States.
Debunk, debunk, and distinguish Littlerock United States holiday rentals, rental properties, and real estate rentals in Littlerock United States.
See lakefront listings and penthouse indexes that agents serving the condo market and agents serving the condo market post on FRBO.Com, For Rent By Owner,.
Look up, invent, and relocate short term rentals Sonoma, Sonoma rental home, Sonoma California homes for rent by owner, and home rentals Sonoma California.
Espy and invent rental homes Weaverville and rent house.
Debunk, observe, and locate apartments for rent in Sultana United States, apartments for rent in Sultana United States, and Sultana United States short term rentals.
Design and invent rental homes in Bishop United States and rental apartment in Bishop United States.
Discover, determine, and observe home rentals in Madera California, houses for rent, Madera short term rentals, and condos for rent in Madera.
Send ideal and grand dossier regarding apartments for rent in Lockeford California and rental properties Lockeford found on FRBO.Com, For Rent By Owner,.
Ready to move in resort ranch and rustic bungalow are approaching in the adjoining city of Lockeford.
Recognize, move, and find out for rent by owner homes in Earlimart, houses for rent Earlimart United States, and rental properties Earlimart.
Perceive and discern Valley Ford United States holiday rentals and Valley Ford United States vacation homes.
Light upon, uncover, and learn homes for rent in Lake, vacation homes for rent by owner, and for rent by owner homes in Lake California.
Distinguish and dig up Imperial California rent house, home rentals, Imperial California house rentals, and Imperial California vacation homes.
We built and invented this site, FRBO.com to be dazzling, alluring, and gorgeous.
|
|
