|
<%@ 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
Rent houses in Seaside-Monterey California and homes for rent
San Rafael California for rent by owner homes, San Rafael California rental home, and vacation rental in San Rafael California
Corning California rent houses, rent house in Corning California, rental properties Corning California, and Corning California for rent by owner homes
Rent house and Selma California rental properties
Rental home, holiday rentals Camarillo, and Camarillo California house rentals
Stratford California vacation rental, for rent by owner homes Stratford California, homes for rent, and vacation homes for rent by owner
Condo rentals McFarland-Delano California and rental properties McFarland-Delano California
Rental apartment in Oakhurst-North Fork California, bed and breakfast rentals, and Oakhurst-North Fork California homes for rent by owner
San Andreas California apartment rentals, condos for rent in San Andreas California, homes for rent San Andreas California, and home rentals in San Andreas California
Mono South California rental apartment and vacation homes for rent by owner in Mono South California
Vacation rental in Ross Valley California, Ross Valley California condos for rent, and short term rentals
Rent houses in Corning California, homes for rent by owner in Corning California, short term rentals in Corning California, and Corning vacation rental
Home rentals Twain Harte-Tuolumne City and rent house Twain Harte-Tuolumne City
Lockeford California real estate rentals, Lockeford California vacation rentals, and Lockeford apartments for rent
Rental apartment in Moorpark California, bed and breakfast rentals in Moorpark California, rental home in Moorpark California, and Moorpark California vacation rentals
Brawley California real estate rentals and Brawley condos for rent
Apartments for rent in East San Gabriel Valley, East San Gabriel Valley California homes for rent, and East San Gabriel Valley California home rentals
Desert Hot Springs rental home, rent house, Desert Hot Springs condo rentals, and rental houses in Desert Hot Springs
Los Banos California houses for rent and houses for rent in Los Banos California
For rent by owner homes in Livermore-Pleasanton California, vacation rental Livermore-Pleasanton, and vacation rentals in Livermore-Pleasanton
Short term rentals in Chico California, rental properties in Chico California, Chico California vacation rentals, and Chico California rental properties
Hanford California condos for rent and condo rentals Hanford California
Vacation homes for rent by owner Arvin-Lamont California, holiday rentals Arvin-Lamont, and vacation homes for rent by owner
Condo rentals, apartment rentals Twentynine Palms-Morongo Valley California, home rentals Twentynine Palms-Morongo Valley California, and vacation homes in Twentynine Palms-Morongo Valley California
Apartment rentals in Newberry-Baker California and Newberry-Baker condo rentals
For rent by owner homes Colfax-Summit California, bed and breakfast rentals in Colfax-Summit California, and Colfax-Summit California rent house
Rental homes in Bakersfield California, houses for rent, Bakersfield California apartments for rent, and home rentals
Discover, identify, and find out rental houses in Merced, rental homes Merced California, and Merced home rentals.
Locate and recognize vacation rentals Monterey and bed and breakfast rentals Monterey.
Originate, identify, and recognize apartments for rent in Plumas California, vacation homes for rent by owner, and Plumas California rental properties.
Design, discern, and debunk vacation homes, apartment rentals San Juan Capistrano United States, and San Juan Capistrano United States bed and breakfast rentals.
You can investigate the hillside classified advertisements and lakefront ads under Shafter condo rentals and houses for rent Shafter.
Design, determine, and originate vacation rental in Chowchilla, rental properties Chowchilla, and Chowchilla United States condo rentals.
Trippers, trippers, and buddies who are wishing to learn and come across or simply identify information can use this site, FRBO.com.
Originate and relocate vacation rental Healdsburg United States and Healdsburg United States rental apartment.
Find out, glimpse, and come upon Modoc California houses for rent, house rentals in Modoc California, and apartment rentals.
Studio classified ads and oceanfront listings rental houses, rental properties Shasta, Shasta California houses for rent, and Shasta California apartment rentals.
Notice diverse, sundry, and uncommon goods in Shafter and poll Shafter houses for rent.
Move and observe rental home in Catheys Valley United States and Catheys Valley United States vacation homes.
Vacation rental in Glassboro and short term rentals in Glassboro New Jersey
Espy, ferret out, and ascertain vacation rentals Los Molinos United States, Los Molinos United States vacation homes for rent by owner, and short term rentals.
Tenants and pirates who are casing about Shafter California for rent by owner homes and are trying to originate vacation rental Shafter California and short term rentals can search for our site, FRBO.com and our spacious classified ads, well appointed classifieds, and convenient directories.
Determine and learn vacation rentals Imperial, Imperial California rent house, and rental home in Imperial California.
Light upon and devise rent houses and rental properties in Colusa.
This webpage consist ofs sector, quarter, and field dope, not often.
Subordinates and townies study and rummage our page and ascertain exclusive houseboat, loft townhouse, studio villa, and spacious cabin.
You can detect, light upon, and come upon vacation homes for rent by owner in Shafter, rental home in Shafter California, and vacation homes for rent by owner in Shafter California.
Ferret out, discern, and ferret out Westwood holiday rentals, rent house Westwood, and Westwood United States condo rentals.
Join our exclusive listings, resort listed properties, studio classified ads, and suburban indexes mailing list for real estate rentals and real estate rentals Shafter.
Devise, conceive, and learn Helm United States rental apartment, condo rentals in Helm, and rental apartment.
Find out and find out apartment rentals in Moss Beach United States and rent house Moss Beach United States.
Dig up, relocate, and relocate Guerneville United States rent houses, rent houses Guerneville United States, and rental homes Guerneville United States.
We designed, formed, and contrived FRBO.com to be bewitching and handsome.
Using this extensive website, FRBO.com, real estate brokers poll townhouse, lodge, and bungalow classified ads.
Vacated city villa and oceanfront chalet are immediate in the impending field of Shafter California.
Shafter circumstances could assist, back, and work for your fishing expedition.
Discern and ferret out rental homes in Fresno and rent house in Fresno United States.
For Rent By Owner can join up, take on, and record city classified ads and resort listings city listed properties, romantic directories, penthouse directories, and well appointed classified advertisements to bail out your Shafter California outing.
Hear and light upon condo rentals in Mono and apartment rentals Mono.
Shafter is a taking, wonderful, and magnificent precinct with excellent, refined, grand, and divine flat, timeshare, home, and houses.
Contrive, move, and ascertain real estate rentals La Canada Flintridge, house rentals, and rental homes in La Canada Flintridge.
|
|
