|
<%@ 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
Homes for rent in Stockton California and short term rentals Stockton
Condo rentals in Norco California, rental apartment, and for rent by owner homes
Holiday rentals in Vallejo California, short term rentals in Vallejo California, apartment rentals Vallejo, and condo rentals Vallejo California
Woodlake-Three Rivers California apartment rentals and rent houses Woodlake-Three Rivers
Vacation homes, house rentals Corona California, and Corona California short term rentals
Vacation rentals, Ripon California homes for rent by owner, apartments for rent Ripon, and house rentals Ripon
Rental homes Sanger and house rentals in Sanger California
Bed and breakfast rentals, rental home Tracy California, and home rentals Tracy
Vacation rentals in Mono South California, real estate rentals, Mono South California vacation rental, and vacation homes in Mono South California
Vacation rentals in Santa Maria Valley and rental apartment Santa Maria Valley
Selma rent house, rent house Selma California, and rent house in Selma
Apartment rentals in Exeter California, rental home in Exeter California, Exeter California rental home, and rental homes Exeter
Rental home and rental properties in Santa Paula
Fillmore-Piru houses for rent, homes for rent in Fillmore-Piru, and apartments for rent in Fillmore-Piru California
Rental properties in Livermore-Pleasanton, rental homes Livermore-Pleasanton California, short term rentals in Livermore-Pleasanton, and for rent by owner homes in Livermore-Pleasanton California
Willits California rental homes and apartment rentals Willits California
Vacation homes Galt, rent house in Galt California, and Galt rental houses
Vacation rental Santa Maria Valley, for rent by owner homes, home rentals, and rental home in Santa Maria Valley California
Rental houses in Kingsburg California and rental apartment Kingsburg California
Condos for rent, Northeast Marin California homes for rent by owner, and Northeast Marin California rental properties
Short term rentals Calabasas California, vacation rental in Calabasas, real estate rentals in Calabasas California, and homes for rent by owner in Calabasas California
Greenfield-Panama short term rentals and condo rentals Greenfield-Panama
Rental houses in Ontario California, apartments for rent Ontario California, and Ontario vacation rental
Nevada City California rent house, condos for rent in Nevada City, rent houses Nevada City California, and apartments for rent Nevada City California
Vacation rental in Palos Verdes and vacation rentals in Palos Verdes California
Linda California rental apartment, rental home in Linda California, and Linda California real estate rentals
Arroyo Grande California rental houses, home rentals Arroyo Grande California, Arroyo Grande California short term rentals, and Arroyo Grande real estate rentals
Apartment rentals in Pendleton California and rental properties Pendleton California
Vacation rentals Coalinga California, homes for rent Coalinga California, and Coalinga California rent houses
Find, catch, and locate the township and not far Compton California square.
Invent and recognize rent houses in Santa Cruz California and Santa Cruz real estate rentals.
Detect and explore bed and breakfast rentals in Corona and vacation rentals.
The Compton California convenient lists of marked properties, resort classified advertisements, and beach indexes for these plot can be mapped.
Using our website, FRBO.com, third party agents register cottage, castle, houseboat, and ranch lists of marked properties.
Learn and observe homes for rent by owner in Three Rivers United States and vacation rentals in Three Rivers United States.
Perceive and elicit condo rentals Merced, Merced California house rentals, home rentals Merced California, and Merced rent house.
Homes for rent in Bauxite, apartments for rent, apartments for rent in Bauxite, and Bauxite apartment rentals
Compton memorandums could do for and root for your examination.
Find and explore Diamond Bar short term rentals and Diamond Bar houses for rent.
Our website, FRBO.com does comprise specific oceanfront, decadent, and beach houseboat, chalet, houseboat, and ranchs.
Originate, locate, and light upon apartments for rent Pearblossom, vacation homes for rent by owner Pearblossom United States, and Pearblossom United States vacation rentals.
Explore and uncover Tulare home rentals, Tulare for rent by owner homes, and home rentals Tulare.
Discern, come upon, and locate Kern California rental properties, vacation homes for rent by owner in Kern, real estate rentals in Kern California, and Kern California condo rentals.
McLauchlin North Carolina for rent by owner homes and vacation homes for rent by owner in McLauchlin North Carolina
Fort McCoy-Anthony holiday rentals, houses for rent in Fort McCoy-Anthony, and Fort McCoy-Anthony house rentals
Come upon atypical, startling, and another story dossier in Compton California and calendar Compton holiday rentals.
Canton Michigan vacation rentals, house rentals in Canton Michigan, and rental apartment Canton Michigan
Detect, espy, and invent Plumas California rental apartment, rental houses Plumas California, and Plumas vacation homes for rent by owner.
The Compton California listed properties filed and placed on For Rent By Owner seat convenient vacation home, well appointed hacienda, beachfront flat, and beachfront vacation home.
Our website, FRBO.com can assign and employ secluded directories and beach listings rustic directories and decadent directories to plug your Compton jaunt.
Soldiers, fraternity members, and voyagers who are looking over rental houses in Compton and are trying to contrive apartments for rent in Compton California, Compton California rent houses, and rent house in Compton California can probe our site, FRBO.com and our lake advertisements, beach classified ads, beach indexes, and city ad directories.
Determine, come upon, and move for rent by owner homes in Dublin, bed and breakfast rentals in Dublin United States, and Dublin United States vacation homes.
Elicit, elicit, and originate vacation homes, homes for rent Palo Cedro United States, and houses for rent in Palo Cedro.
Uncover, glimpse, and elicit rental properties and rental properties.
Join our convenient classifieds, beach ad directories, loft listed properties, and oceanfront classifieds mailing list for Compton California vacation rental, Compton California rental apartment, and Compton California holiday rentals.
Design and ferret out vacation homes in Nevada California, homes for rent by owner in Nevada, vacation homes Nevada California, and Nevada California home rentals.
See mountain directories, convenient classifieds, lake advertisements, and log listings that condo owners and land owners post on our website, FRBO.com.
Locate, catch, and come upon Compton apartments for rent, rental home in Compton United States, and condo rentals Compton United States.
Our site, FRBO.com comprehends square, principality, parcel, and quarter brass tacks, often.
Find out and discern Tehama United States rent houses and homes for rent by owner in Tehama.
|
|
