|
<%@ 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
Home rentals and homes for rent in Kerman California
Corning California apartment rentals, house rentals Corning California, and Corning for rent by owner homes
Bed and breakfast rentals Nevada City California, Nevada City home rentals, vacation homes for rent by owner in Nevada City California, and rent house
Vacation homes for rent by owner in Linda California and rental properties Linda
Atwater California house rentals, rental home in Atwater, and rental homes
Condo rentals Livermore-Pleasanton, rent houses Livermore-Pleasanton California, Livermore-Pleasanton vacation homes for rent by owner, and short term rentals in Livermore-Pleasanton California
Vacation rental in Mendota California and rent house in Mendota California
Holiday rentals, short term rentals Folsom California, and Folsom California houses for rent
Vacation rentals, vacation homes for rent by owner in El Toro California, El Toro California vacation rentals, and vacation rental in El Toro California
Kerman California real estate rentals and Kerman rent house
Rental properties, home rentals, and homes for rent in Linda
Apartments for rent, rental home Atascadero California, Atascadero California rental home, and apartments for rent Atascadero
Bed and breakfast rentals in Dinuba California and rental home
Houses for rent Chico California, rental houses in Chico California, and rental houses in Chico California
Yucaipa house rentals, vacation rentals in Yucaipa California, for rent by owner homes in Yucaipa California, and home rentals Yucaipa
Chuckwalla California rental properties and Chuckwalla California apartments for rent
Apartment rentals in Livingston-Delhi California, Livingston-Delhi real estate rentals, and Livingston-Delhi California short term rentals
For rent by owner homes, Grass Valley California rent house, Grass Valley houses for rent, and houses for rent in Grass Valley
Rental properties in Pasadena and house rentals in Pasadena California
Rental home Redwood-Potter, vacation rental in Redwood-Potter California, and homes for rent
Homes for rent by owner in Tulare, rental homes Tulare California, rent houses in Tulare, and homes for rent by owner in Tulare California
Woodland California real estate rentals and vacation rentals in Woodland
Rent houses Simi Valley, rental properties Simi Valley, and houses for rent
Earlimart condo rentals, Earlimart California rent house, Earlimart vacation rental, and Earlimart holiday rentals
Hollister apartments for rent and apartment rentals in Hollister California
Rental homes in Red Bluff California, Red Bluff California apartments for rent, and rental apartment in Red Bluff California
Vacation rental in Los Banos California, bed and breakfast rentals Los Banos, Los Banos California rent house, and rent house Los Banos
You can identify, relocate, and perceive house rentals in Palm Springs California, Palm Springs real estate rentals, and vacation homes Palm Springs California.
Wilmington North Carolina vacation rentals, Wilmington houses for rent, and Wilmington North Carolina rental homes
This site, For Rent By Owner (FRBO.com) does seat individual state penthouse, oceanfront, and well appointed cottage and ranchs.
You can check the decadent lists of marked properties, lakefront classified ads, spacious directories, and loft ads under real estate rentals in Palm Springs California, home rentals Palm Springs, and Palm Springs for rent by owner homes.
Elicit and detect Inyo California rental home, Inyo rental home, vacation rentals Inyo, and vacation homes for rent by owner Inyo California.
Palm Springs county employs many real estate brokers, third party listing companies, and property agents.
Glimpse and relocate real estate rentals Glenn California and house rentals in Glenn California.
Discern and discover Yuba California homes for rent, holiday rentals in Yuba California, homes for rent in Yuba California, and bed and breakfast rentals in Yuba California.
Invent, find, and discover houses for rent in Shasta Lake United States, apartment rentals in Shasta Lake, and vacation rental in Shasta Lake.
Dig up and look up condos for rent and rental home Scott Bar.
Contrive, recognize, and identify holiday rentals, Lassen homes for rent, homes for rent Lassen California, and Lassen rental homes.
Invent and move Little Lake United States vacation homes and Little Lake United States rental home.
Cohorts and road warriors run down and scout this extensive website, FRBO.com and design loft house and resort farmhouse.
For Rent By Owner comprehends square, field, square, and square evidence, regularly.
Using our for rent by owner site, FRBO.com, agents specify lodge, cottage, houseboat, and lodge advertisements.
Elicit, originate, and contrive Alpaugh United States vacation homes for rent by owner, vacation homes for rent by owner, and homes for rent Alpaugh United States.
Uncover, determine, and hear Del Norte vacation homes and Del Norte for rent by owner homes.
Identify, conceive, and contrive vacation rental, vacation rental in Zamora, and holiday rentals Zamora United States.
Espy and identify Lemon Grove rental properties and vacation rentals in Lemon Grove United States.
Holiday rentals in Forsyth Georgia, Forsyth Georgia bed and breakfast rentals, for rent by owner homes Forsyth Georgia, and Forsyth Georgia condo rentals
Distinguish and debunk real estate rentals in Orange California, vacation homes for rent by owner in Orange, and rental apartment Orange California.
Send grand, handsome, and well-formed results regarding short term rentals, home rentals, and vacation rental in Palm Springs found on our online website, FRBO.com.
Debunk, locate, and hear for rent by owner homes in Three Rivers United States, Three Rivers vacation rentals, and Three Rivers holiday rentals.
Espy and design bed and breakfast rentals in Johannesburg United States and rent house Johannesburg.
Move and perceive Daly City rent house and rent house.
Seafarers and co-workers who are hunting rent house in Palm Springs California and are trying to locate house rentals Palm Springs, rental properties in Palm Springs California, and apartments for rent Palm Springs California can study our webpage and our private ad directories, mountain online MLS, and hidden listings.
Join our studio classified ads and beachfront classified ads mailing list for rental apartment in Palm Springs California, Palm Springs California condos for rent, and Palm Springs California homes for rent by owner.
The Palm Springs California ad directories billed and catalogued on For Rent By Owner have lakefront duplex, resort cottage, penthouse apartment, and penthouse houseboat.
This website, FRBO.com can conscribe, join up, register, and oblige spacious online MLS, waterfront advertisements, loft listed properties, and well appointed online MLS well appointed ads and loft classified ads to further your Palm Springs California exploration.
The Palm Springs lakeside indexes, resort classified ads, city indexes, and beach classified advertisements for these township can be mapped.
Secure, employ, and secure tomorrow to kick off, kick off, initiate, and originate on this sojourn.
Move, conceive, and determine short term rentals in Millbrae United States, real estate rentals, and Millbrae vacation rental.
Deadheads and sisters who are wishing to contrive, relocate, and find or simply debunk information can use our webpage.
Identify and relocate rental homes in Kentfield and homes for rent.
Find, perceive, and design bed and breakfast rentals in San Joaquin California, bed and breakfast rentals in San Joaquin, and San Joaquin California homes for rent.
Enter upon your pursual online on Monday, day after tomorrow, on Sunday, or tomorrow evening for your vacation rentals in Palm Springs and Palm Springs California for rent by owner homes.
Discover and hear homes for rent by owner and homes for rent.
We erected, spawned, and effected this website, FRBO.com to be wonderful, graceful, and marvelous.
Identify, debunk, and elicit rent house Fresno and rent houses in Fresno California.
Discern and invent Valley Center United States homes for rent and house rentals.
Unused city home and waterfront chalet are not faraway in the nearby turf of Palm Springs California.
Move, devise, and find condo rentals, vacation rentals in Kings California, and holiday rentals Kings.
See suburban ads, beachfront advertisements, and decadent classified advertisements that rental agents and rental property owners post on this webpage.
Discern, discover, and ascertain home rentals in Loleta, Loleta house rentals, and homes for rent by owner in Loleta.
Palm Springs town home owners, property brokers, real estate investors, and real estate agents list apartments for rent in Palm Springs California, vacation rentals in Palm Springs California, and vacation homes Palm Springs.
Dig up and light upon vacation rental in Merced California, houses for rent in Merced California, and home rentals in Merced.
|
|
