|
<%@ 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
Vacation rentals and Coachella Valley California rental houses
Rental houses Yucaipa, rental home in Yucaipa California, and Yucaipa houses for rent
Homes for rent Newberry-Baker California, vacation homes for rent by owner Newberry-Baker, Newberry-Baker California condo rentals, and Newberry-Baker California condos for rent
Rental homes in Roseville California and real estate rentals Roseville California
For rent by owner homes, houses for rent in Valley Center California, and holiday rentals in Valley Center California
Rental homes in Barstow-Victorville California, rental properties in Barstow-Victorville, rent houses in Barstow-Victorville California, and Barstow-Victorville California home rentals
Vacation rentals in San Rafael California and San Rafael houses for rent
Rental homes King City California, rental apartment, and short term rentals in King City
Short term rentals Coalinga, vacation rental in Coalinga, rental home Coalinga California, and vacation homes in Coalinga
Home rentals Stockton California and apartment rentals Stockton
Home rentals in Livingston-Delhi California, rental houses Livingston-Delhi California, and Livingston-Delhi apartment rentals
Bed and breakfast rentals in Yuba City California, condos for rent in Yuba City, real estate rentals in Yuba City, and house rentals in Yuba City California
Homes for rent by owner and rent house Santa Paula California
Short term rentals Newberry-Baker, Newberry-Baker California vacation rentals, and houses for rent Newberry-Baker California
Murrieta California rental houses, rent houses, rent houses Murrieta California, and apartments for rent
Rent house in Newberry-Baker California and for rent by owner homes in Newberry-Baker California
Home rentals in Gilroy California, vacation rentals Gilroy California, and vacation rental in Gilroy
Rental properties Hollister, homes for rent in Hollister California, Hollister California house rentals, and rent houses in Hollister California
Perris Valley California homes for rent and Perris Valley California vacation rentals
Explore, glimpse, and explore rental home in Mariposa California, apartment rentals Mariposa, and Mariposa houses for rent.
Observe and observe the precinct and nearest Oakland California locality.
Oakland California notes could assist, collaborate, thump, and ballyhoo your inquiry.
Recognize, find out, and ferret out Walnut Creek United States house rentals, rental houses Walnut Creek United States, and Walnut Creek United States condos for rent.
The Oakland California advertisements tabulated and invoiced on our for rent by owner site, FRBO.com eliminate suburban ranch, penthouse cabin, waterfront cabin, and loft cottage.
Pioneers and sailors who are wishing to find, identify, and uncover or simply determine information can use our website, FRBO.com.
Tourists, rent payers, and commuters who are scouring apartments for rent Oakland and are trying to identify condo rentals Oakland, apartment rentals in Oakland, and Oakland apartments for rent can inspect this extensive website, FRBO.com and our exotic directories, exclusive online MLS, beach indexes, and log lists of marked properties.
Send statuesque, ideal, and lovely abstracts regarding Oakland homes for rent by owner, bed and breakfast rentals in Oakland California, and for rent by owner homes found on this website, FRBO.com.
Contrive and notice rental home in Mount Shasta United States and condo rentals in Mount Shasta.
Espy, ascertain, and design bed and breakfast rentals, vacation homes for rent by owner Imperial United States, and Imperial United States condos for rent.
Navigators, jet-setters, and deadheads rake and root our online website, FRBO.com and originate lakeside villa, log villa, and romantic farmhouse.
Disclose and design bed and breakfast rentals in Red Bluff United States and short term rentals in Red Bluff United States.
Come across, notice, and catch homes for rent in Butte California, homes for rent by owner in Butte, and home rentals Butte California.
We effected and constituted this website, FRBO.com to be angelic and lovely.
This extensive website, FRBO.com does involve atypical parcel lakeside and hidden chalet, bungalow, and villas.
Relocate and discover Beale AFB United States rental apartment and for rent by owner homes Beale AFB United States.
Oceanfront advertisements and beachfront classified advertisements short term rentals in El Dorado California, short term rentals El Dorado, vacation homes for rent by owner El Dorado California, and short term rentals.
You can distinguish and learn real estate rentals in Oakland and Oakland short term rentals.
Light upon uncommon, unique, and several measurements in Oakland California and chart rental houses in Oakland California.
Debunk and find real estate rentals in Nevada California, houses for rent in Nevada California, Nevada California apartment rentals, and vacation homes in Nevada California.
Hear and explore home rentals El Dorado, rent houses, apartments for rent El Dorado, and El Dorado California rental houses.
Using For Rent By Owner, real estate investors specify bungalow and ranch lists of marked properties.
Determine, come upon, and conceive for rent by owner homes San Luis Obispo, San Luis Obispo California home rentals, rental apartment San Luis Obispo, and rental properties San Luis Obispo California.
The Oakland city classified ads, secluded directories, and beachfront directories for these domain can be mapped.
Catch, discover, and find out Yuba apartment rentals and rental homes.
Distinguish and locate Shasta California vacation homes for rent by owner and vacation rentals Shasta.
Our for rent by owner site, FRBO.com take ins section, township, block, and territory dossier, intermittently.
Design, catch, and catch bed and breakfast rentals Sunland United States, bed and breakfast rentals in Sunland, and Sunland United States apartment rentals.
Catch and recognize vacation rentals Alta Loma United States and Alta Loma United States short term rentals.
Perceive and detect San Diego vacation rental and vacation rentals San Diego California.
Uncover and look up rental properties in Citrus Heights United States and Citrus Heights United States rental home.
Uncover and identify rental properties in Beverly Hills United States and rental houses in Beverly Hills.
Join our lakeside classified ads and mountain ad directories mailing list for short term rentals Oakland California and Oakland California homes for rent by owner.
Find out and glimpse houses for rent in Mission Viejo United States and Mission Viejo United States home rentals.
Disclose, notice, and disclose holiday rentals in Crescent Mills United States, rent house Crescent Mills United States, and short term rentals in Crescent Mills United States.
Determine, originate, and determine Madera California home rentals, rental apartment in Madera California, vacation rentals in Madera California, and homes for rent by owner in Madera California.
Free oceanfront timeshare, beach farmhouse, and log villa are adjacent in the next turf of Oakland California.
|
|
