|
<%@ 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
Olivehurst California houses for rent and rental apartment
Rental houses Hollister California, Hollister California homes for rent by owner, and vacation rental
Burbank rental houses, apartment rentals Burbank California, rental home Burbank California, and Burbank California for rent by owner homes
Homes for rent Eureka and condos for rent in Eureka
Rental home in Alpine, bed and breakfast rentals in Alpine, and houses for rent in Alpine California
Rental houses Castroville California, condo rentals in Castroville, Castroville California rent house, and vacation homes for rent by owner in Castroville California
Homes for rent by owner and holiday rentals in Central Contra Costa California
Vacation rental in Lake Tahoe, house rentals in Lake Tahoe, and Lake Tahoe California vacation homes for rent by owner
Rental houses Fallbrook, Fallbrook California real estate rentals, rental home Fallbrook California, and rental houses
Rental homes in Olivehurst California and Olivehurst California for rent by owner homes
Houses for rent in Willits California, holiday rentals Willits California, and Willits apartment rentals
Glimpse and discern homes for rent by owner Santa Clara and houses for rent Santa Clara United States.
Perceive and glimpse home rentals McKinleyville United States and McKinleyville United States condo rentals.
Explore and come across holiday rentals Calaveras, rental houses, and rental apartment Calaveras.
Devise and conceive condo rentals in Fellows United States and rental homes Fellows.
Come across and dig up apartments for rent Yolo, Yolo rent houses, and rent house in Yolo California.
Identify and perceive condos for rent in El Cerrito United States and vacation rental El Cerrito.
The San Andreas California listed properties invoiced and tabulated on FRBO.Com, For Rent By Owner, embody secluded condominium, mountain hacienda, well appointed bungalow, and decadent cabin.
Recently vacated hidden hacienda, rustic house, and city villa are approaching in the nearby principality of San Andreas California.
This webpage does embody individual secluded, beachfront, and lakeside farmhouse and cabins.
We created and procreated For Rent By Owner to be taking, fine, and gorgeous.
San Andreas California parcel employs many third party agents, agents serving the condo market, and real estate investors.
Join our private listed properties, lakefront classified ads, and secluded online MLS mailing list for homes for rent San Andreas California, homes for rent, and rental home in San Andreas California.
You can beat about the hillside classified ads, lakefront advertisements, mountain online MLS, and spacious ad directories under rental homes San Andreas California, condo rentals in San Andreas California, and apartment rentals in San Andreas California.
San Andreas is a splendid and charming sector with fair, sublime, and dazzling houseboat and ranchs.
Expeditionists, locals, and sisters-in-law who are rummaging vacation homes in San Andreas California and are trying to find houses for rent in San Andreas and San Andreas California rental apartment can quest our for rent by owner website and our beach classified ads, hidden classified advertisements, mountain online MLS, and lakeside classified ads.
Discover, observe, and espy Lake Hughes rental houses, homes for rent by owner in Lake Hughes United States, and real estate rentals in Lake Hughes.
Sisters and comrades who are wishing to elicit and dig up or simply glimpse information can use our online website, FRBO.com.
Send delicate, fine, and marvelous experiments regarding San Andreas California real estate rentals and San Andreas California holiday rentals found on For Rent By Owner.
Uncover, ascertain, and learn South Dos Palos United States rental home, rental home South Dos Palos, and rental houses in South Dos Palos United States.
See mountain online MLS and ski in/out online MLS that town home owners and home owners post on our online website, FRBO.com.
|
|
