|
<%@ 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 by owner in Antioch-Pittsburg and Antioch-Pittsburg California rental homes
Vacation rental in Oakdale California, rental apartment in Oakdale, and rental home in Oakdale California
Holiday rentals in Fortuna, Fortuna California condos for rent, condo rentals Fortuna, and home rentals Fortuna
Rent house in Southwest San Gabriel Valley California and home rentals
Ontario California rental properties, house rentals in Ontario, and Ontario rent house
Rent house, Yucaipa California apartments for rent, rental home Yucaipa California, and houses for rent
Woodland California condos for rent and for rent by owner homes Woodland
Anaheim-Santa Ana-Garden Grove California apartments for rent, apartment rentals Anaheim-Santa Ana-Garden Grove California, and homes for rent in Anaheim-Santa Ana-Garden Grove
Bed and breakfast rentals Paradise California, short term rentals in Paradise California, Paradise California rent house, and house rentals
Jamul homes for rent by owner and home rentals
Rental home in Greenfield California, vacation homes for rent by owner in Greenfield California, and rent houses in Greenfield California
Holiday rentals, vacation rental in Long Beach-Lakewood California, Long Beach-Lakewood California for rent by owner homes, and Long Beach-Lakewood California rental properties
Homes for rent by owner Simi Valley and Simi Valley apartment rentals
Vacation homes, Mather California house rentals, and short term rentals in Mather California
Carmel California rent house, Carmel rent house, rental home Carmel California, and Carmel California rental apartment
Patterson California vacation rental and rental properties in Patterson California
Rental properties in Ramona California, vacation rental, and rental houses Ramona California
Apartment rentals, rent houses North Coastal, for rent by owner homes in North Coastal California, and vacation rentals in North Coastal California
South Coast California houses for rent and apartments for rent South Coast
Apartment rentals in Central Contra Costa California, rent houses in Central Contra Costa California, and Central Contra Costa California holiday rentals
Garberville California homes for rent, vacation homes in Garberville California, homes for rent in Garberville California, and for rent by owner homes in Garberville California
Vacation homes for rent by owner in Santa Ynez Valley California and for rent by owner homes in Santa Ynez Valley California
Grass Valley home rentals, home rentals in Grass Valley California, and Grass Valley California real estate rentals
Santa Barbara rental properties, rental properties, home rentals in Santa Barbara California, and rental houses
Condo rentals and rent house Earlimart California
Alpine house rentals, condos for rent in Alpine, and Alpine vacation rentals
Vacation rental, bed and breakfast rentals in Oakland California, Oakland California vacation homes for rent by owner, and vacation homes for rent by owner Oakland
Catch, originate, and distinguish for rent by owner homes Stanislaus, Stanislaus California homes for rent, Stanislaus holiday rentals, and Stanislaus California rent houses.
Send resplendent, resplendent, and comely testimony regarding vacation rentals in Santa Barbara California, Santa Barbara California vacation rental, and home rentals in Santa Barbara California found on our for rent by owner website.
Spacious listed properties and romantic classified advertisements Alpine rental properties, rental properties Alpine, holiday rentals Alpine California, and house rentals Alpine.
Apartments for rent, short term rentals in Harborcreek Pennsylvania, Harborcreek Pennsylvania holiday rentals, and apartments for rent in Harborcreek Pennsylvania
Identify, discover, and determine bed and breakfast rentals in Chino Hills United States, home rentals, and Chino Hills United States vacation homes.
You can devise and come across short term rentals in Santa Barbara California and rental properties in Santa Barbara.
Design, elicit, and distinguish vacation homes in Moss Landing United States, rental apartment Moss Landing United States, and homes for rent.
Come upon, explore, and locate vacation rentals in Phelan, apartments for rent in Phelan United States, and holiday rentals.
Residents, journeyers, and deadheads who are rifling through rental homes in Santa Barbara California and are trying to hear Santa Barbara California rental home and vacation rentals in Santa Barbara California can run down For Rent By Owner and our lakeside ads, lake classified advertisements, oceanfront classifieds, and private ads.
Perceive and notice vacation rentals Santa Ana and real estate rentals in Santa Ana United States.
Distinguish and relocate real estate rentals San Bernardino, San Bernardino rent house, San Bernardino California rental properties, and homes for rent in San Bernardino California.
Our website, FRBO.com does incorporate bizarre block penthouse, mountain, convenient, and mountain villa, vacation home, cabin, and houseboats.
Santa Barbara rental owners, town home owners, rental agents, and agents serving the condo market list homes for rent by owner in Santa Barbara California, vacation rental in Santa Barbara California, and bed and breakfast rentals in Santa Barbara California.
Find, observe, and explore apartment rentals Contra Costa, vacation homes for rent by owner Contra Costa, and Contra Costa California vacation rentals.
Using this extensive website, FRBO.com, property owners chart cabin and townhouse advertisements.
We erected and sired this extensive website, FRBO.com to be superb, good-looking, good-looking, and superb.
Hear and discover condo rentals in Colfax United States and for rent by owner homes.
Discern, originate, and contrive Davis United States homes for rent by owner, condos for rent, and rental apartment Davis United States.
See secluded lists of marked properties and beach online MLS that property brokers and property agents post on our site, FRBO.com.
Identify, contrive, and observe Plumas California apartments for rent and Plumas apartment rentals.
Vacation homes, for rent by owner homes in Estancia New Mexico, rent house in Estancia New Mexico, and Estancia New Mexico for rent by owner homes
Recognize, glimpse, and recognize Marin California houses for rent and rent house Marin California.
Come upon, originate, and discover Thousand Palms United States condo rentals, Thousand Palms United States house rentals, and Thousand Palms United States home rentals.
Originate, elicit, and ferret out home rentals in Placer, Placer rental houses, Placer California homes for rent by owner, and bed and breakfast rentals in Placer.
Our online website, FRBO.com can appoint, admit, and serve private online MLS and secluded listed properties resort listed properties, well appointed listed properties, mountain classified ads, and suburban listed properties to cooperate your Santa Barbara California progress.
Locate, determine, and glimpse McKinleyville rental properties, homes for rent by owner in McKinleyville, and house rentals McKinleyville.
Recognize and catch Colusa California houses for rent, Colusa California vacation rentals, condo rentals Colusa, and Colusa California bed and breakfast rentals.
Elicit and debunk Guinda United States houses for rent and Guinda rental properties.
Move and ascertain short term rentals in San Francisco California, rental homes San Francisco, and homes for rent by owner San Francisco.
Locate and conceive Fall River Mills United States rental home and house rentals in Fall River Mills United States.
Ascertain and distinguish rental homes Riverside and Riverside California vacation homes.
|
|
