|
<%@ 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
House rentals Madera California and rental home Madera
Soledad California bed and breakfast rentals, rental properties in Soledad, and apartment rentals Soledad
Rental homes, holiday rentals Auburn California, rental houses, and vacation rental Auburn
Holiday rentals Selma and holiday rentals Selma
Home rentals Orosi-Cutler, Orosi-Cutler California real estate rentals, and homes for rent Orosi-Cutler
Santa Cruz house rentals, holiday rentals Santa Cruz, vacation homes in Santa Cruz California, and vacation homes in Santa Cruz California
Rental houses in Inglewood and Inglewood California houses for rent
Vacation rental Lindsay California, rental houses Lindsay California, and vacation homes for rent by owner in Lindsay California
Vacation rentals Anaheim-Santa Ana-Garden Grove, Anaheim-Santa Ana-Garden Grove California house rentals, rental home Anaheim-Santa Ana-Garden Grove, and rental home in Anaheim-Santa Ana-Garden Grove
Vacation rental Glendale and bed and breakfast rentals in Glendale
Corning homes for rent, Corning California apartment rentals, and houses for rent Corning
Rental properties, Oroville California vacation homes for rent by owner, vacation rental Oroville California, and house rentals in Oroville California
Bed and breakfast rentals and holiday rentals in Santa Barbara California
Vacation homes for rent by owner, Hollister California condo rentals, and vacation homes for rent by owner
Thousand Oaks California rental properties, rent houses in Thousand Oaks California, for rent by owner homes Thousand Oaks California, and Thousand Oaks for rent by owner homes
Real estate rentals in Los Angeles California and Los Angeles home rentals
Rental homes East Kern California, rental apartment East Kern California, and East Kern houses for rent
Disclose and debunk homes for rent in Pismo Beach United States and vacation rentals in Pismo Beach United States.
South Coastside California is a nice and pretty tract with alluring, taking, fair, and fascinating villa, castle, lodge, and apartments.
Locate, identify, and espy Mono homes for rent and condo rentals.
South Coastside California plot employs many property managers, brokers leasing foreclosures, landlords, and property brokers.
Hear and discern homes for rent by owner Sacramento California and vacation homes in Sacramento California.
Invent and notice condo rentals in Kerman and rent houses in Kerman United States.
Move, catch, and discover rental homes Corona del mar United States, vacation rental Corona del mar United States, and Corona del mar United States vacation homes.
List and engage this weekend to begin and embark on on this traveling.
Our for rent by owner site, FRBO.com does embody distinct kingdom loft, beachfront, hidden, and beach home, apartment, and duplexs.
Find unconventional, rare, and novel proof in South Coastside and note South Coastside apartments for rent.
Get cracking your research online this weekend, in the next few days, or next weekend for your rental apartment in South Coastside California, short term rentals in South Coastside California, and South Coastside California vacation rental.
Using this webpage, property brokers record cabin, home, and villa listed properties.
Ferret out, discern, and debunk Redwood City rental homes, Redwood City United States rental houses, and rent houses in Redwood City.
Identify, perceive, and ascertain homes for rent by owner, El Verano United States vacation rental, and home rentals.
Find, uncover, and glimpse Santa Cruz California rental homes, rental houses Santa Cruz California, and apartment rentals.
Devise, espy, and catch the zone and adjoining South Coastside California patch.
Pre-leased lakeside ranch and resort vacation home are adjacent in the convenient city of South Coastside California.
The South Coastside classified ads recorded and entered on FRBO.Com, For Rent By Owner, eliminate waterfront home and hillside castle.
|
|
