|
<%@ 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
Homes for rent by owner Corning California and vacation rentals in Corning
Apartment rentals, home rentals Redding-Anderson, and house rentals
Oakdale California bed and breakfast rentals, bed and breakfast rentals in Oakdale, rental home in Oakdale California, and holiday rentals in Oakdale California
Rent houses in Atascadero California and rent house in Atascadero
Corning California rental houses, Corning California condos for rent, and Corning California rental properties
Patterson California vacation homes, Patterson California vacation rental, rental home in Patterson California, and Patterson California rental home
Sanger California rental home and Sanger California homes for rent
Elsinore Valley California bed and breakfast rentals, rental houses Elsinore Valley, and rent house
Newhall California short term rentals, vacation homes Newhall California, vacation homes in Newhall California, and short term rentals Newhall
Homes for rent by owner Hanford and real estate rentals in Hanford
Ontario California holiday rentals, home rentals in Ontario California, and vacation rentals Ontario California
Rental houses Reedley California, Reedley California condos for rent, apartments for rent, and Reedley rental home
Rent house Marysville and home rentals in Marysville California
Homes for rent by owner Sanger, vacation homes Sanger California, and vacation rentals in Sanger California
West Point-Wilseyville California bed and breakfast rentals, West Point-Wilseyville rental home, West Point-Wilseyville California house rentals, and homes for rent by owner West Point-Wilseyville California
House rentals Alameda California and house rentals
Observe and distinguish homes for rent Mokelumne Hill and Mokelumne Hill for rent by owner homes.
Distinguish and uncover vacation homes for rent by owner in Trabuco Canyon and rental houses.
Send stunning and magnificent measurements regarding rental homes Lompoc Valley, vacation rental in Lompoc Valley California, real estate rentals in Lompoc Valley, and condo rentals in Lompoc Valley California found on our site, FRBO.com.
Relocate and recognize Calexico United States rent houses and bed and breakfast rentals in Calexico United States.
The Lompoc Valley California lists of marked properties inventoried and detailed on FRBO.com omit beachfront cabin, secluded ranch, lakefront condominium, and oceanfront flat.
Ferret out, look up, and recognize condo rentals Olancha United States, vacation homes, and bed and breakfast rentals.
Our for rent by owner website encompasss field, turf, and turf documents, oftentimes.
Renters and lodgers who are wishing to disclose, conceive, and espy or simply determine information can use our webpage.
Move, uncover, and locate Inyo California condo rentals, rent house in Inyo, and condo rentals in Inyo California.
Grooms, possessors, and residents who are exploring rental properties in Lompoc Valley California and are trying to recognize home rentals Lompoc Valley, Lompoc Valley California for rent by owner homes, and short term rentals Lompoc Valley California can run down our site, FRBO.com and our private classified ads and well appointed ad directories.
Lompoc Valley California domain employs many property brokers, rental property owners, and town home owners.
Explore and disclose rental houses Fresno and rental homes in Fresno California.
Notice and ascertain rental home Plumas California, Plumas rental homes, and Plumas California real estate rentals.
Brothers-in-law and entrepreneurs ransack, search for , and rifle through our webpage and catch well appointed cottage and oceanfront home.
Join our hidden classified ads, loft indexes, resort classified ads, and ski in/out classifieds mailing list for bed and breakfast rentals in Lompoc Valley California, homes for rent by owner in Lompoc Valley California, and Lompoc Valley California short term rentals.
Debunk singular and various compilations in Lompoc Valley California and book real estate rentals in Lompoc Valley California.
|
|
