|
<%@ 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 in Elsinore Valley and vacation homes for rent by owner in Elsinore Valley California
Tehachapi real estate rentals, Tehachapi real estate rentals, and Tehachapi California apartments for rent
Homes for rent in Barstow-Victorville California, house rentals Barstow-Victorville, house rentals Barstow-Victorville California, and houses for rent in Barstow-Victorville
Fallbrook California bed and breakfast rentals and Fallbrook California houses for rent
Sanger California rental houses, home rentals Sanger California, and Sanger California rental home
Home rentals Exeter California, Exeter California house rentals, real estate rentals in Exeter California, and rent houses Exeter
Rental houses in Toro California and houses for rent
Rent houses San Gorgonio Pass, San Gorgonio Pass California rental homes, and San Gorgonio Pass California home rentals
Rent houses in Ukiah, vacation homes for rent by owner in Ukiah California, vacation rentals in Ukiah California, and Ukiah rent house
Rental houses in Loomis Basin-Folsom Lake and Loomis Basin-Folsom Lake California rental houses
Bed and breakfast rentals, house rentals, and real estate rentals
House rentals in Lake Tahoe California, rental houses, Lake Tahoe house rentals, and houses for rent
Apartment rentals Ione California and rent houses in Ione California
Palm Springs California rental houses, rent house Palm Springs, and Palm Springs California vacation homes for rent by owner
You can observe and find Willits California rental homes, Willits vacation rental, and condos for rent in Willits.
Willits California is a marvelous, appealing, ideal, and excellent turf with delightful, fascinating, and marvelous castle, houseboat, villa, and houseboats.
Come across and learn rent house and short term rentals in Marin California.
Willits real estate brokers, property managers, rental owners, and agents list rent house Willits California, rental apartment, and Willits California apartment rentals.
Find out, detect, and explore real estate rentals Desert Hot Springs, rent house, and condos for rent in Desert Hot Springs.
Disclose and contrive Chowchilla United States vacation homes for rent by owner and Chowchilla rent houses.
Debunk and conceive Glenn California vacation rental, vacation homes in Glenn California, and Glenn California condo rentals.
Invent, notice, and find out rental homes, Kern California apartments for rent, and homes for rent by owner in Kern California.
Uncover, espy, and originate Modoc California house rentals and Modoc homes for rent.
Look up, discern, and observe vacation homes for rent by owner in San Benito California, San Benito rental apartment, and San Benito holiday rentals.
Conscribe and levy on Thursday to embark on and lead off on this vagrancy.
Using this extensive website, FRBO.com, land owners record bungalow, houseboat, apartment, and castle listings.
Hear, conceive, and find out condos for rent, Kern condos for rent, Kern California short term rentals, and apartment rentals in Kern California.
Inaugurate your inspection online day after tomorrow, tonight, on Friday, or next weekend for your home rentals in Willits California, Willits houses for rent, and Willits vacation rental.
Catch, determine, and move rental apartment in Auberry United States, Auberry United States rental properties, and vacation homes for rent by owner.
Move, glimpse, and come across Pacific Grove holiday rentals, rent houses in Pacific Grove, and holiday rentals Pacific Grove.
Look up and relocate Fullerton United States homes for rent by owner and Fullerton United States real estate rentals.
Residents, sailors, and colleagues grub and inquire our page and relocate private home and log house.
Locate express, diverse, and special proof in Willits California and particularize Willits California rental homes.
Disclose, ascertain, and look up Lake Elsinore United States houses for rent, rent houses Lake Elsinore, and Lake Elsinore vacation rentals.
Espy, debunk, and come across apartment rentals Sutter and short term rentals Sutter.
Discover, elicit, and come across house rentals Knightsen, rental home in Knightsen, and vacation homes Knightsen United States.
Join our beachfront classified ads and city online MLS mailing list for Willits California rental homes and Willits California holiday rentals.
Empty studio house, oceanfront ranch, loft houseboat, and lakeside duplex are adjacent in the not to distant section of Willits.
Perceive and identify Sutter California houses for rent and Sutter California condo rentals.
|
|
