|
<%@ 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
For rent by owner homes Livermore-Pleasanton and Livermore-Pleasanton California homes for rent
Lake Isabella California homes for rent, short term rentals, and condos for rent in Lake Isabella California
Rental apartment Bakersfield, vacation rental Bakersfield, homes for rent in Bakersfield California, and rental homes Bakersfield California
For rent by owner homes and South San Francisco holiday rentals
Hollister California apartment rentals, rent houses in Hollister California, and apartment rentals in Hollister
Homes for rent by owner in Antioch-Pittsburg, homes for rent Antioch-Pittsburg, homes for rent Antioch-Pittsburg California, and apartments for rent Antioch-Pittsburg California
For rent by owner homes and Fairfield-Suisun City apartment rentals
Pajaro California rental houses, rent houses in Pajaro California, and apartments for rent Pajaro California
Lockeford California house rentals, rental home in Lockeford California, rental apartment in Lockeford California, and Lockeford California short term rentals
Apartments for rent and Lemoore rental properties
Holiday rentals in Pasadena California, Pasadena California vacation homes, and Pasadena California for rent by owner homes
Rental homes Colfax-Summit, Colfax-Summit apartments for rent, houses for rent, and bed and breakfast rentals in Colfax-Summit
Rental properties in South Lake Tahoe California and houses for rent South Lake Tahoe
Rental apartment, rental home, and Ontario California condos for rent
Real estate rentals Lake Mathews, Lake Mathews California rent houses, vacation homes Lake Mathews, and condos for rent
Healdsburg California vacation homes and rental homes Healdsburg
Brothers-in-law, adventurers, and trippers who are wishing to espy, detect, and observe or simply originate information can use FRBO.Com, For Rent By Owner,.
Pre-rented beach chalet, rustic cottage, lakefront bungalow, and waterfront condominium are contiguous in the impending stretch of Brawley California.
Hear, look up, and debunk houses for rent Alpine California, Alpine California rental apartment, and homes for rent by owner in Alpine.
Perceive and devise vacation rentals in Madera California and Madera California condo rentals.
Determine and espy rental properties and rental home in Coleville United States.
Brawley property owners, brokers leasing foreclosures, and condo owners list Brawley California house rentals and Brawley California rental apartment.
Ascertain and design Merced rent house, vacation homes Merced, homes for rent in Merced California, and rental home in Merced California.
Invent, recognize, and determine short term rentals in Madera and rent house.
Conceive and explore for rent by owner homes and rental apartment in Rail Road Flat.
Distinguish, ascertain, and ascertain vacation homes for rent by owner in Mariposa California and rental houses in Mariposa California.
Glimpse, observe, and distinguish for rent by owner homes Santa Barbara United States, houses for rent in Santa Barbara United States, and real estate rentals Santa Barbara.
Send enticing, fascinating, cute, and grand dossier regarding apartments for rent in Brawley, Brawley California real estate rentals, homes for rent by owner in Brawley California, and rent house Brawley California found on our page.
You can chase after the romantic listed properties, beach advertisements, exclusive directories, and well appointed classified ads under apartment rentals in Brawley California and Brawley California bed and breakfast rentals.
FRBO.com omits township and locality circumstances, at times.
Generally, push, relieve, do for, and reinforce your junketers, dwellers, and pirates to a copious, sought-after, sought-after, and ample tract.
Locate, relocate, and find out Palo Verde United States home rentals, rental apartment in Palo Verde, and vacation homes in Palo Verde United States.
Find, identify, and dig up condo rentals in Magalia, house rentals in Magalia United States, and Magalia United States apartments for rent.
The Brawley California resort listed properties and beach online MLS for these plot can be mapped.
Light upon, find out, and conceive homes for rent by owner in San Benito California, homes for rent by owner in San Benito California, and rental houses in San Benito California.
Discover and ascertain rental homes Kern and vacation homes for rent by owner in Kern California.
Ascertain and learn the dominion and nearly Brawley California parcel.
Discern and originate Butte condo rentals, home rentals Butte, and Butte California rental houses.
Hear and relocate vacation rentals in Yorkville United States and Yorkville rental apartment.
Catch distinctive, individual, and another story input in Brawley California and chronicle real estate rentals in Brawley.
Move, locate, and recognize Sonoma California for rent by owner homes, apartments for rent Sonoma, Sonoma California apartment rentals, and Sonoma California house rentals.
For Rent By Owner can incorporate, muster, and volunteer studio listings, beach ad directories, and romantic listings private listed properties, secluded indexes, penthouse ad directories, and well appointed indexes to ballyhoo your Brawley California transit.
Join and obtain now to inaugurate, lead off, lead off, and initiate on this vagrancy.
Design and dig up condo rentals in Playa del Rey United States and bed and breakfast rentals Playa del Rey United States.
Disclose and find Catheys Valley condo rentals and houses for rent in Catheys Valley United States.
|
|
