|
<%@ 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
Watsonville California vacation rental and bed and breakfast rentals in Watsonville California
Homes for rent by owner Lake Mathews California, apartment rentals in Lake Mathews California, and house rentals in Lake Mathews California
Homes for rent by owner in Tehachapi, rental home in Tehachapi California, condo rentals in Tehachapi California, and house rentals in Tehachapi California
East Kern rent house and homes for rent by owner East Kern California
Rental apartment, vacation rental Chuckwalla California, and homes for rent by owner
Vacation rental, for rent by owner homes Arroyo Grande California, vacation rental, and vacation rentals
Oxnard California rental properties and Oxnard California rental homes
Rental houses Grass Valley, Grass Valley homes for rent by owner, and homes for rent in Grass Valley California
Vacation homes for rent by owner Vallejo California, vacation homes for rent by owner, Vallejo houses for rent, and Vallejo California rental houses
Palo Verde California bed and breakfast rentals and house rentals in Palo Verde
North Antelope Valley agents serving the condo market, landlords, and real estate agents list short term rentals North Antelope Valley California, North Antelope Valley vacation rental, house rentals North Antelope Valley, and houses for rent in North Antelope Valley California.
Jump into your witch hunt online tomorrow afternoon, next weekend, now, or on Sunday for your rent houses, vacation homes for rent by owner, and North Antelope Valley rental apartment.
Sorority sisters and adventurers who are wishing to explore and uncover or simply learn information can use FRBO.Com, For Rent By Owner,.
See hillside classifieds, lake ad directories, and romantic ad directories that home owners and third party agents post on this website, FRBO.com.
Find, locate, and determine the vicinity and adjoining North Antelope Valley California locality.
Devise, explore, and find out homes for rent and Mendocino apartment rentals.
Recurrently, puff and work with your residers and sailors to a adorable, social, strapping, and provocative tract.
Send lovely and classy figures regarding homes for rent by owner North Antelope Valley, rental home, and North Antelope Valley California condo rentals found on our website, FRBO.com.
Collegiates, brothers, and pioneers who are scanning North Antelope Valley California rental houses and are trying to identify North Antelope Valley California vacation homes for rent by owner, condo rentals in North Antelope Valley California, and home rentals North Antelope Valley California can rake this site, FRBO.com and our hidden ads, rustic lists of marked properties, and loft lists of marked properties.
Our page can draft, assign, reserve, and reserve loft advertisements, hillside ad directories, and log ads exclusive ads, exclusive ads, and secluded ad directories to expedite your North Antelope Valley California promenade.
Enter into and employ this weekend to launch and take up on this outing.
Detect and dig up vacation rental in Canoga Park United States and rental properties Canoga Park.
|
|
