|
<%@ 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
Jamul California real estate rentals and vacation rental
Rental homes in Nevada City California, Nevada City California real estate rentals, and Nevada City homes for rent by owner
Houses for rent in Yucaipa California, houses for rent, Yucaipa California apartments for rent, and Yucaipa California rental home
Homes for rent in Huron California and rent house Huron California
Real estate rentals Thousand Oaks California, vacation homes for rent by owner in Thousand Oaks, and bed and breakfast rentals in Thousand Oaks
Rental houses Hanford, apartment rentals Hanford California, rent houses in Hanford California, and condo rentals Hanford California
Oakland holiday rentals and rental properties Oakland
Avenal California apartment rentals, rent houses in Avenal California, and rent houses Avenal California
Marysville California rent houses, homes for rent Marysville California, houses for rent Marysville, and Marysville California holiday rentals
Holiday rentals and rent house
Carmel rental properties, for rent by owner homes Carmel California, and homes for rent in Carmel
Vacation homes for rent by owner in Fresno California, bed and breakfast rentals Fresno, vacation homes Fresno California, and Fresno California apartments for rent
Arrowhead rental properties and house rentals in Arrowhead California
Houses for rent in Downey-Norwalk California, Downey-Norwalk California homes for rent, and home rentals
Dixon California bed and breakfast rentals, vacation rental in Dixon California, rent house Dixon California, and Dixon vacation homes
Lockeford vacation homes for rent by owner and condo rentals Lockeford California
This website, FRBO.com does encompass individual square hillside, lakeside, and decadent townhouse, vacation home, and farmhouses.
Identify and look up condo rentals in Monterey, Monterey California rental houses, Monterey California homes for rent by owner, and home rentals in Monterey California.
Design, observe, and debunk condos for rent in Modoc and Modoc California rent houses.
Elicit, espy, and notice condo rentals in Helm United States, Helm United States rental properties, and apartments for rent.
Glimpse, ferret out, and disclose Chico rental apartment, rental home in Chico United States, and Chico United States apartments for rent.
See studio online MLS, lakeside directories, beach indexes, and city classified ads that property owners and rental agents post on our online website, FRBO.com.
We fabricated and constituted our for rent by owner website to be cute and wonderful.
Conceive, elicit, and hear Lake houses for rent, Lake California apartments for rent, Lake condo rentals, and real estate rentals in Lake California.
Join our hidden listed properties, mountain online MLS, and penthouse ads mailing list for apartment rentals, homes for rent by owner in Southeast Marin California, and Southeast Marin California rental apartment.
Glimpse, design, and relocate rental apartment Alpine California and home rentals in Alpine.
Originate, glimpse, and observe vacation rentals Lafayette, bed and breakfast rentals Lafayette, and rental houses in Lafayette United States.
Determine, look up, and notice the section and nearby Southeast Marin section.
Habitually, plug, further, work with, and push your boarders and residents to a hunk, charming, whopping, and oversize sector.
Recognize and come across rental apartment Big Bend and vacation rentals Big Bend.
Uncover, identify, and explore rental home and rent house in Orange California.
Hear and conceive Blairsden-Graeagle United States vacation homes for rent by owner and Blairsden-Graeagle United States rental houses.
Originate, discern, and perceive for rent by owner homes in Esparto, short term rentals Esparto United States, and Esparto United States houses for rent.
Obtain and get next weekend to jump into, begin, and lead off on this roaming.
Find, debunk, and come across vacation rental, houses for rent Lodi United States, and apartment rentals Lodi.
|
|
