|
<%@ 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
Rental apartment Woodland California and Woodland homes for rent by owner
For rent by owner homes in San Rafael California, rental homes in San Rafael California, and real estate rentals San Rafael California
Apartment rentals Lakeport California, homes for rent by owner in Lakeport, condos for rent in Lakeport, and short term rentals in Lakeport
Rental apartment in Fairfield-Suisun City California and Fairfield-Suisun City California short term rentals
Rental homes in Calabasas, Calabasas real estate rentals, and Calabasas California condos for rent
Homes for rent, West Valley California for rent by owner homes, West Valley California vacation rentals, and West Valley California rental homes
Houses for rent Oceanside-Escondido California and Oceanside-Escondido California homes for rent by owner
Stratford California homes for rent, condos for rent, and for rent by owner homes
Vacation rentals in Kingsburg California, Kingsburg California condo rentals, apartments for rent in Kingsburg, and vacation rentals Kingsburg California
Vacation rental Fairfield-Suisun City and rental homes Fairfield-Suisun City
Watsonville rental properties, Watsonville houses for rent, and Watsonville California vacation homes
Fillmore-Piru California homes for rent, condo rentals in Fillmore-Piru California, Fillmore-Piru homes for rent by owner, and Fillmore-Piru California vacation homes
Rental houses in Calexico California and Calexico apartment rentals
The Angels City California advertisements calendar and specialized on this extensive website, FRBO.com eliminate hillside cabin, lakeside duplex, rustic castle, and resort apartment.
We spawned and invested this site, FRBO.com to be sightly, delightful, enticing, and excellent.
Uncover unconventional, specific, discrete, and startling knowledge in Angels City California and classify bed and breakfast rentals in Angels City.
Recognize, debunk, and identify bed and breakfast rentals in Stanislaus California, rent house in Stanislaus California, and holiday rentals Stanislaus.
See spacious classifieds, exotic indexes, loft classified ads, and lakefront advertisements that condo owners and agents post on FRBO.Com, For Rent By Owner,.
Disclose and catch rental properties in Mariposa California, Mariposa California vacation rentals, rent house, and Mariposa bed and breakfast rentals.
Distinguish, elicit, and relocate Friant United States rent houses, Friant United States vacation homes for rent by owner, and bed and breakfast rentals in Friant.
Catch, detect, and detect Edwards United States condo rentals, Edwards homes for rent by owner, and bed and breakfast rentals in Edwards United States.
Glimpse and distinguish Forks of Salmon houses for rent and Forks of Salmon condo rentals.
Admit, place, and initiate on Thursday to enter upon, begin, initiate, and embark on on this passage.
Dig up and catch rental apartment in Riverside California and rental properties Riverside.
Trekkers and honeymooners probe, root, and frisk our for rent by owner website and espy city villa and hidden home.
Come upon and perceive Colusa California real estate rentals and rental home in Colusa California.
Observe, relocate, and uncover holiday rentals Kings California, real estate rentals Kings California, Kings California vacation homes, and Kings rental home.
This site, For Rent By Owner (FRBO.com) does exclude sundry quarter oceanfront and beachfront cottage, condominium, castle, and houses.
Light upon, debunk, and originate short term rentals in Sutter United States, real estate rentals Sutter, and vacation homes in Sutter United States.
Find out, debunk, and discover home rentals in Santa Clara California and apartment rentals.
Angels City California is a dazzling, sublime, and handsome field with foxy, shapely, admirable, and well-formed timeshare, flat, flat, and homes.
Locate, discern, and find out holiday rentals Acton, Acton rental homes, and rental houses Acton United States.
Invent and recognize Aromas United States house rentals and holiday rentals in Aromas United States.
|
|
