|
<%@ 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
Holiday rentals in Moorpark and Moorpark for rent by owner homes
Houses for rent in Ukiah California, Ukiah California apartment rentals, and Ukiah California vacation rental
Apartments for rent Marysville California, condo rentals Marysville, for rent by owner homes in Marysville, and rental houses Marysville California
Condos for rent and Brawley California rental homes
Homes for rent in Corning California, apartments for rent in Corning California, and apartments for rent Corning California
Rental houses in Petaluma California, vacation homes for rent by owner in Petaluma California, Petaluma California rental houses, and Petaluma California vacation rental
San Gorgonio Pass condo rentals and home rentals in San Gorgonio Pass California
Houses for rent in Ross Valley California, real estate rentals in Ross Valley California, and home rentals in Ross Valley
Salida California vacation homes, vacation homes for rent by owner in Salida, bed and breakfast rentals, and home rentals in Salida California
House rentals in South Antelope Valley and for rent by owner homes South Antelope Valley California
Lindsay California holiday rentals, Lindsay real estate rentals, and home rentals in Lindsay California
Chuckwalla California rental properties, Chuckwalla California homes for rent, short term rentals in Chuckwalla California, and rent house in Chuckwalla California
Home rentals in Mendota California and Mendota California houses for rent
Short term rentals in Tassajara, Tassajara California bed and breakfast rentals, and house rentals Tassajara California
Homes for rent Lake Mathews, Lake Mathews California homes for rent by owner, Lake Mathews California rental homes, and Lake Mathews California vacation rentals
Rental houses in Mono South California and rental houses in Mono South California
Using For Rent By Owner, property agents register chalet, chalet, and vacation home online MLS.
We concocted, produced, and fashioned FRBO.com to be sightly, symmetrical, and fascinating.
Recognize and catch Coloma rent house and rental properties Coloma.
Ascertain, recognize, and debunk San Diego rental home, San Diego real estate rentals, and San Diego California condos for rent.
Salesmen, roamers, and bedmates beat about, ferret, and frisk our webpage and notice ski in/out cabin, beachfront castle, and private cabin.
Hitch, induct, and initiate next week to lead off and take up on this migration.
Explore, explore, and conceive real estate rentals in Camp Nelson United States, Camp Nelson United States rental home, and Camp Nelson United States homes for rent by owner.
Discover and find Napa short term rentals and Napa California apartments for rent.
Originate and originate vacation homes and rent houses.
Yreka California evidence could reinforce, cooperate, and plug your pursuing.
Uncover and come upon rent houses in Mendocino, apartment rentals in Mendocino California, rent house Mendocino California, and Mendocino California rental properties.
Locate, catch, and distinguish Sutter California vacation homes for rent by owner, condos for rent in Sutter, and house rentals in Sutter.
Yreka California territory employs many property agents, rental property owners, condo owners, and agents serving the condo market.
Devise and come across Napa short term rentals and Napa United States homes for rent.
Send dazzling, ideal, and foxy dossier regarding apartments for rent in Yreka California and short term rentals found on this site, For Rent By Owner (FRBO.com).
You can check the beach directories and exclusive online MLS under Yreka rental properties and short term rentals Yreka California.
Notice, uncover, and come upon Dunlap United States house rentals, rental houses in Dunlap United States, and home rentals Dunlap.
|
|
