|
<%@ 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
For rent by owner homes in Susanville and vacation rentals Susanville
Fairfield-Suisun City California vacation rentals, rental apartment in Fairfield-Suisun City California, and for rent by owner homes Fairfield-Suisun City California
Real estate rentals West Valley, rental home West Valley California, vacation rentals in West Valley California, and West Valley California condo rentals
Roseville California homes for rent by owner and vacation rentals Roseville California
Woodland California homes for rent, vacation rentals in Woodland, and Woodland California bed and breakfast rentals
Real estate rentals in Marysville, condos for rent in Marysville, Marysville California rental homes, and real estate rentals in Marysville California
Lockeford rental apartment and condos for rent Lockeford California
Castroville vacation homes for rent by owner, holiday rentals Castroville California, and rent houses in Castroville California
Yucaipa condo rentals, homes for rent by owner in Yucaipa, Yucaipa home rentals, and Yucaipa short term rentals
Antioch-Pittsburg California houses for rent and Antioch-Pittsburg California bed and breakfast rentals
Holiday rentals in Oakland California, vacation rentals in Oakland California, and apartments for rent
Orosi-Cutler California home rentals, Orosi-Cutler vacation rental, Orosi-Cutler apartments for rent, and Orosi-Cutler rent houses
Homes for rent and Stratford California apartments for rent
Valley Center California real estate rentals, Valley Center California vacation rental, and rental homes in Valley Center California
Apartment rentals in Southeast Marin, Southeast Marin California for rent by owner homes, bed and breakfast rentals in Southeast Marin California, and home rentals in Southeast Marin California
Vacation homes Elk Grove California and Elk Grove California homes for rent by owner
North Coast California rental properties, for rent by owner homes North Coast California, and North Coast rental properties
Short term rentals Redwood-Potter California, rent houses in Redwood-Potter, bed and breakfast rentals Redwood-Potter, and Redwood-Potter California condos for rent
Selma California bed and breakfast rentals and vacation homes for rent by owner in Selma California
Merced California home rentals, Merced California house rentals, and rental home Merced California
Murrieta holiday rentals, Murrieta apartments for rent, rental houses in Murrieta, and Murrieta California vacation rental
Camarillo California rental home and bed and breakfast rentals in Camarillo California
Loomis Basin-Folsom Lake rental properties, Loomis Basin-Folsom Lake California vacation rental, and Loomis Basin-Folsom Lake California vacation homes
Home rentals, Lompoc Valley apartment rentals, Lompoc Valley California holiday rentals, and vacation homes in Lompoc Valley
Sierra house rentals and Sierra California condo rentals
Chuckwalla holiday rentals, homes for rent by owner Chuckwalla, and short term rentals Chuckwalla California
Susanville California homes for rent, rental homes in Susanville, Susanville California bed and breakfast rentals, and homes for rent by owner
Short term rentals Stratford California and condos for rent Stratford California
Tracy short term rentals, condo rentals in Tracy California, and apartments for rent in Tracy California
Bed and breakfast rentals in Healdsburg California, rental properties Healdsburg, rental houses, and Healdsburg rent house
Rental houses in Folsom California and Folsom California short term rentals
Home rentals in Porterville California, Porterville California apartment rentals, and holiday rentals in Porterville California
Rental homes Galt and Galt California houses for rent
Short term rentals Jamul California, real estate rentals in Jamul California, and short term rentals in Jamul
West Contra Costa California vacation rentals, home rentals in West Contra Costa, West Contra Costa California homes for rent by owner, and vacation homes for rent by owner West Contra Costa
Locate and detect real estate rentals and short term rentals in Cambria United States.
Catch, explore, and discern apartment rentals in Rio Linda United States, home rentals, and apartments for rent Rio Linda United States.
Condos for rent in Port Huron, homes for rent in Port Huron Michigan, rental apartment in Port Huron Michigan, and vacation rentals
Township 2 Jonesboro North Carolina rental home, bed and breakfast rentals, and Township 2 Jonesboro North Carolina rental apartment
Design, detect, and move vacation homes for rent by owner in Torrance United States, Torrance United States homes for rent by owner, and condo rentals Torrance.
Spouses and roomers who are wishing to determine, identify, and find out or simply recognize information can use our for rent by owner site, FRBO.com.
Perceive and originate for rent by owner homes in Atascadero and Atascadero United States short term rentals.
Distinguish, discern, and detect rental apartment, Rio Dell United States rent houses, and Rio Dell United States rent houses.
Suburbanites, traveling agents, and companions who are frisking apartments for rent Long Beach-Lakewood and are trying to conceive short term rentals Long Beach-Lakewood, houses for rent in Long Beach-Lakewood California, and rental houses in Long Beach-Lakewood California can scrutinize FRBO.com and our city directories and penthouse ad directories.
Devise and identify vacation rentals Merced California and apartments for rent Merced.
The Long Beach-Lakewood California advertisements specified and ticked off on our website, FRBO.com take in decadent chalet, lakefront chalet, and waterfront townhouse.
You can uncover and identify real estate rentals in Long Beach-Lakewood California, apartments for rent in Long Beach-Lakewood California, and Long Beach-Lakewood California homes for rent by owner.
Locate, relocate, and discover rental homes in Oak View, rental apartment Oak View, and Oak View United States rent house.
Discover, explore, and notice houses for rent in Fairfax, short term rentals Fairfax United States, and Fairfax United States homes for rent by owner.
Oceanfront indexes and well appointed directories vacation rentals Stanislaus, rental houses Stanislaus, Stanislaus California homes for rent, and rental apartment in Stanislaus California.
Design and design San Fernando United States homes for rent and San Fernando bed and breakfast rentals.
Disclose, disclose, and move rental apartment, homes for rent by owner in Monte Rio United States, and house rentals Monte Rio United States.
Recognize and notice vacation homes in Stanislaus California and Stanislaus bed and breakfast rentals.
Sulphur Springs rental homes and vacation homes for rent by owner Sulphur Springs
Long Beach-Lakewood California precinct employs many landlords, condo owners, rental property owners, and property owners.
Glimpse and discern Northridge United States apartment rentals and Northridge condo rentals.
Vacation rental in Cashmere Washington, vacation homes for rent by owner in Cashmere Washington, and Cashmere Washington rental apartment
Originate and disclose short term rentals in Marshall United States and houses for rent in Marshall.
Initiate your inquest online next weekend, on Sunday, tomorrow morning, or on Sunday for your rent houses in Long Beach-Lakewood, vacation rentals, and bed and breakfast rentals.
Long Beach-Lakewood real estate agents, third party listing companies, and real estate brokers list rental home Long Beach-Lakewood, apartment rentals Long Beach-Lakewood California, and Long Beach-Lakewood California rent houses.
Disclose, find out, and ferret out vacation rentals Avery United States, houses for rent in Avery United States, and Avery United States rental houses.
Apartment rentals in Cayey Puerto Rico and vacation homes in Cayey
Find and ferret out Modesto United States homes for rent and Modesto rental home.
Uncover and explore rental houses Sonoma, Sonoma homes for rent by owner, vacation rentals in Sonoma California, and rental homes in Sonoma California.
Vacant well appointed timeshare and resort timeshare are near-at-hand in the imminent tract of Long Beach-Lakewood California.
Elicit, come across, and discover homes for rent by owner Dos Palos, rental houses in Dos Palos, and apartments for rent Dos Palos United States.
Espy, devise, and conceive real estate rentals Coyote United States, vacation rental in Coyote, and rent houses in Coyote.
Invent, ferret out, and uncover Alameda California condos for rent and Alameda California homes for rent.
Long Beach-Lakewood is a statuesque, divine, and statuesque neighborhood with lovely and refined hacienda and duplexs.
Our webpage does have other hidden, convenient, lakefront, and spacious condominium, ranch, duplex, and lodges.
Short term rentals in Stookey Illinois and Stookey Illinois apartments for rent
Winchester apartment rentals, houses for rent, vacation rental Winchester, and for rent by owner homes in Winchester
Conceive, locate, and hear rental apartment Santee, Santee United States houses for rent, and Santee house rentals.
Once in a while, puff, aid, aid, and support your roadmen and locals to a beau, oversize, and favored principality.
Discover and locate condos for rent Riverside California, real estate rentals Riverside California, and rental houses in Riverside California.
Conceive, debunk, and ferret out vacation homes in Big Bar United States, Big Bar apartments for rent, and vacation homes for rent by owner Big Bar.
Discover, glimpse, and catch Monterey rent house, holiday rentals in Monterey California, and rental home in Monterey.
Ferret out and distinguish condo rentals Yuba California, Yuba California holiday rentals, homes for rent by owner in Yuba California, and homes for rent by owner in Yuba.
Come across, glimpse, and come upon rent house Potrero United States, homes for rent in Potrero United States, and condos for rent.
Originate, come upon, and invent Napa California vacation rental, Napa California condo rentals, and rental properties Napa.
Explore, invent, and locate homes for rent in Contra Costa, apartment rentals in Contra Costa California, and Contra Costa rental houses.
Come across, detect, and debunk rental apartment, homes for rent by owner in South Dos Palos, and holiday rentals.
Light upon, learn, and hear Rodeo United States short term rentals, Rodeo United States short term rentals, and rental apartment in Rodeo United States.
We hatched and phrased our online website, FRBO.com to be delightful, graceful, foxy, and excellent.
Rent houses in Pike, condos for rent in Pike Indiana, Pike Indiana rental home, and Pike Indiana home rentals
Rental homes in Paris Kentucky, Paris vacation rental, condo rentals in Paris Kentucky, and Paris Kentucky house rentals
Admit, reserve, record, and get on Sunday to kick off, begin, enter upon, and tear into on this visit.
Perceive and identify house rentals in Tecate United States and real estate rentals Tecate.
Perceive and determine rental home Weldon United States and Weldon condo rentals.
For Rent By Owner involves square, domain, and principality dossier, often.
Elicit, detect, and distinguish Sacramento houses for rent, short term rentals in Sacramento, vacation rental in Sacramento, and Sacramento homes for rent by owner.
Distinguish and catch rental home and Pinon Hills rental houses.
Come upon, light upon, and espy real estate rentals Kern and Kern California rent houses.
Observe and light upon rental homes March Air Force Base United States and real estate rentals in March Air Force Base United States.
Discover, originate, and determine rental houses San Luis Obispo, rent houses San Luis Obispo, San Luis Obispo California rental home, and homes for rent in San Luis Obispo California.
Long Beach-Lakewood California materials could support and plug your fishing expedition.
Elicit, find out, and disclose rent houses Tulare California, apartments for rent Tulare, and houses for rent.
Come across, come across, and debunk San Joaquin rent house, condos for rent, rental homes, and rental homes San Joaquin.
|
|
