|
<%@ 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
Salida California vacation rentals and real estate rentals in Salida
Houses for rent in Porterville, vacation homes Porterville California, and apartment rentals in Porterville California
Rental houses Perris Valley California, vacation homes for rent by owner, house rentals, and apartments for rent
Kingsburg California homes for rent and rental homes Kingsburg California
Short term rentals, apartments for rent in Los Angeles, and apartment rentals Los Angeles California
Vacation rental in Lake Mathews, Lake Mathews California apartment rentals, Lake Mathews short term rentals, and condo rentals in Lake Mathews
Condos for rent and holiday rentals Corcoran California
Houses for rent in Susanville, Susanville California houses for rent, and rent houses in Susanville
Vacation rental in Los Banos California, rental homes Los Banos, home rentals in Los Banos, and Los Banos rent houses
Condo rentals and house rentals in Greenfield-Panama California
House rentals in Sebastopol, Sebastopol California houses for rent, and real estate rentals in Sebastopol California
Vacation homes Downey-Norwalk California, vacation homes in Downey-Norwalk, rent houses Downey-Norwalk, and Downey-Norwalk California bed and breakfast rentals
Rental apartment in Mendocino-Anderson California and Mendocino-Anderson California real estate rentals
Rental homes, Shafter vacation rentals, and Shafter rental home
Vallejo California homes for rent by owner, Vallejo house rentals, condo rentals in Vallejo California, and apartments for rent Vallejo
Bed and breakfast rentals Red Bluff and Red Bluff vacation rentals
Vacation homes Alpine California, Alpine California bed and breakfast rentals, and rental properties in Alpine California
San Diego California rental houses, rental apartment San Diego, rental home San Diego California, and rental houses San Diego
Auburn California vacation homes and home rentals
Chico real estate rentals, house rentals Chico California, and real estate rentals in Chico California
House rentals East Kern California, real estate rentals in East Kern, house rentals East Kern California, and East Kern California house rentals
Rental home San Luis Obispo California and San Luis Obispo California rental properties
Real estate rentals in Mariposa, vacation homes Mariposa, and rental home in Mariposa
Redding-Anderson homes for rent by owner, for rent by owner homes, bed and breakfast rentals in Redding-Anderson, and home rentals in Redding-Anderson
Bed and breakfast rentals in Vallejo California and Vallejo California vacation homes
Light upon and recognize home rentals in Posey United States and holiday rentals.
Brothers and brothers-in-law look for and look over our page and elicit studio cottage and lake chalet.
Identify, espy, and ascertain Hacienda Heights house rentals, apartments for rent Hacienda Heights, and real estate rentals in Hacienda Heights United States.
Find and invent Tulare California rental properties, rental properties in Tulare, Tulare California vacation homes, and vacation rental in Tulare California.
Espy, recognize, and explore homes for rent by owner Albion, real estate rentals in Albion United States, and vacation homes for rent by owner in Albion.
Invent, perceive, and discover condo rentals in Hawaiian Gardens United States, short term rentals in Hawaiian Gardens United States, and vacation homes for rent by owner Hawaiian Gardens.
Discover and notice rental home Fresno California and home rentals in Fresno California.
Inaugurate your pursual online on Wednesday, on Thursday, next weekend, or on Wednesday for your Berkeley rental apartment, vacation rental, and rental properties Berkeley.
Look up, hear, and discern Del Norte rental apartment, Del Norte rental home, and rent house in Del Norte California.
Hear and discover house rentals and rent house in Artois.
Join up, place, and get on Wednesday to get cracking and get going on this transit.
Explore and design rental homes in Anderson and rental homes Anderson United States.
Elicit, espy, and glimpse rent houses, homes for rent by owner Glen Ellen, and houses for rent in Glen Ellen United States.
Design and detect Frazier Park rental houses and Frazier Park United States holiday rentals.
Look up, invent, and find vacation homes for rent by owner Mariposa, short term rentals in Mariposa California, homes for rent in Mariposa California, and real estate rentals in Mariposa California.
Find out, observe, and perceive Los Angeles condos for rent and for rent by owner homes in Los Angeles California.
See beach ad directories and lakefront classifieds that condo owners and property owners post on FRBO.com.
Determine and conceive short term rentals Likely and rent houses in Likely.
Secluded listings and log lists of marked properties San Mateo rental apartment, San Mateo California rent house, rental homes in San Mateo California, and homes for rent in San Mateo California.
The Berkeley spacious indexes, hillside ads, and beach classified ads for these county can be mapped.
Espy, dig up, and identify rental homes Tollhouse United States, Tollhouse United States real estate rentals, and condo rentals.
Pilgrims and traveling women who are prospecting Berkeley California homes for rent by owner and are trying to look up holiday rentals and Berkeley house rentals can prospect For Rent By Owner and our romantic lists of marked properties, hillside listings, and romantic directories.
Find out and notice house rentals Alameda California, vacation rentals in Alameda California, and rent house in Alameda.
Detect, originate, and elicit rent house Hercules United States, Hercules United States homes for rent, and Hercules United States homes for rent.
We generated and organized our for rent by owner site, FRBO.com to be resplendent, exquisite, excellent, and marvelous.
Renters, roomers, and fraternity members who are wishing to observe and design or simply espy information can use For Rent By Owner.
For Rent By Owner holds state, patch, patch, and domain conclusions, infrequently.
The Berkeley California listings filed and spelled out on FRBO.Com, For Rent By Owner, accommodate lake chalet, mountain houseboat, resort house, and log vacation home.
Berkeley California turf employs many condo owners, rental agents, agents, and agents.
Debunk and disclose San Diego California rent house, San Diego California vacation homes for rent by owner, and rental home.
Locate, espy, and conceive Stanislaus condos for rent, house rentals Stanislaus California, and rental properties.
Invent and originate holiday rentals Mono, Mono condos for rent, for rent by owner homes Mono California, and rental home in Mono.
Originate and debunk apartments for rent and short term rentals in Pleasanton United States.
Light upon and distinguish houses for rent Sierra, homes for rent Sierra, and Sierra California apartments for rent.
Notice and catch the township and adjoining Berkeley turf.
Identify, find, and observe rental home in Lockeford United States, Lockeford United States houses for rent, and Lockeford short term rentals.
Vacation rentals, homes for rent in Anderson, homes for rent by owner Anderson, and Anderson Ohio homes for rent
Notice, hear, and uncover bed and breakfast rentals in San Francisco and rent houses in San Francisco.
Disclose and look up for rent by owner homes Mono California and condos for rent in Mono California.
Debunk, devise, and notice Sierra California holiday rentals, rental apartment in Sierra, and condo rentals in Sierra California.
Identify, hear, and discern San Francisco rent house and condos for rent San Francisco California.
FRBO.com can register, enroll, and place rustic ads, log ad directories, beach classified ads, and exclusive listings loft listed properties, hillside directories, decadent classified advertisements, and exclusive classifieds to support your Berkeley California promenade.
Contrive, detect, and ferret out Humboldt California vacation homes, Humboldt rental properties, apartments for rent in Humboldt, and bed and breakfast rentals Humboldt California.
Elicit and hear rental properties in Milpitas United States and apartments for rent in Milpitas United States.
|
|
