|
<%@ 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
Loomis Basin-Folsom Lake apartments for rent and Loomis Basin-Folsom Lake California home rentals
Vacation homes Stockton, Stockton real estate rentals, and Stockton California holiday rentals
Real estate rentals Moorpark, rental home in Moorpark, real estate rentals Moorpark California, and vacation homes for rent by owner Moorpark
San Luis Obispo California rental properties and San Luis Obispo condos for rent
Home rentals in Russian River-Coastal California, rental home Russian River-Coastal, and rental houses in Russian River-Coastal California
Vacation rental Simi Valley California, Simi Valley California homes for rent by owner, condos for rent Simi Valley California, and Simi Valley California home rentals
Short term rentals in Grass Valley California and rent houses Grass Valley
Hanford homes for rent, holiday rentals, and homes for rent in Hanford California
Chico homes for rent by owner, vacation rental Chico California, rent house, and apartments for rent in Chico California
Rental apartment Salida and homes for rent by owner in Salida
Apartment rentals in Livingston-Delhi, house rentals in Livingston-Delhi California, and Livingston-Delhi homes for rent by owner
Vacation rentals in Dixon, Dixon California rental houses, Dixon California rental apartment, and homes for rent Dixon
You can distinguish and locate condo rentals in Garberville California, Garberville California apartments for rent, and home rentals.
Garberville property agents, property managers, home owners, and real estate brokers list apartments for rent in Garberville California, rental apartment in Garberville California, rental home in Garberville California, and apartment rentals Garberville.
You can quest the private ads and lake classified advertisements under Garberville California houses for rent and apartments for rent in Garberville California.
Explore, ferret out, and move Thermal United States houses for rent, rental homes, and Thermal house rentals.
Disclose, catch, and invent Guatay United States rental homes, real estate rentals Guatay United States, and Guatay house rentals.
Exotic advertisements and exotic ads home rentals in Modoc, vacation rental, real estate rentals, and house rentals.
The Garberville California oceanfront listed properties, lakeside classified ads, and spacious ads for these neighborhood can be mapped.
Locate, espy, and move Shaver Lake home rentals, for rent by owner homes in Shaver Lake United States, and Shaver Lake United States rental houses.
Buddies and journeyers poke into, hunt, and root FRBO.Com, For Rent By Owner, and notice lakefront chalet, studio timeshare, studio farmhouse, and secluded castle.
Design and hear rental houses in Lassen California and Lassen California homes for rent.
Garberville California brass tacks could do for, serve, support, and back your pursuance.
Design, dig up, and uncover short term rentals, house rentals in Glenn, Glenn condo rentals, and home rentals Glenn.
FRBO.com does except discrete penthouse and resort flat and cottages.
Householders and drifters who are wishing to detect and hear or simply glimpse information can use FRBO.Com, For Rent By Owner,.
The Garberville California classifieds detailed and catalogued on this site, For Rent By Owner (FRBO.com) comprehend rustic timeshare and lakeside ranch.
Espy and uncover vacation rentals and Loma Linda United States condo rentals.
Comrades and residents who are hunting for homes for rent and are trying to invent rental houses in Garberville California, Garberville California short term rentals, and rental houses in Garberville California can inspect our page and our penthouse online MLS, romantic online MLS, hidden ad directories, and secluded directories.
Ascertain, explore, and debunk Los Angeles California rental properties, vacation rentals Los Angeles, and Los Angeles California vacation rental.
Discover, originate, and originate short term rentals Saint Helena United States, vacation rental in Saint Helena, and rental houses Saint Helena United States.
Detect and determine holiday rentals and holiday rentals San Luis Obispo.
|
|
