|
<%@ 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 Lemoore California and Lemoore condo rentals
Homes for rent in Colfax-Summit, Colfax-Summit California apartments for rent, and vacation homes for rent by owner in Colfax-Summit California
House rentals in Waterford California, rental houses in Waterford, Waterford rental properties, and Waterford California vacation rental
Alameda rental houses and rent houses Alameda
Apartments for rent in North Coast, houses for rent in North Coast California, and houses for rent North Coast California
Rental properties in Sacramento California, vacation rentals Sacramento California, Sacramento California condos for rent, and Sacramento California rental houses
Chowchilla California condo rentals and Chowchilla California home rentals
Huron California for rent by owner homes, Huron homes for rent by owner, and Huron California rental apartment
Rental houses, rental homes in Loomis Basin-Folsom Lake California, Loomis Basin-Folsom Lake California vacation homes, and Loomis Basin-Folsom Lake rental properties
Rental properties and rent house Idyllwild
Arvin-Lamont California rental home, vacation homes for rent by owner in Arvin-Lamont, and vacation rentals Arvin-Lamont
For rent by owner homes in Torrance California, homes for rent by owner in Torrance California, rental properties in Torrance, and vacation homes
South Coast California houses for rent and South Coast California homes for rent by owner
Bed and breakfast rentals in West Contra Costa California, vacation homes for rent by owner in West Contra Costa, and rental home West Contra Costa California
Rent house in Mariposa California, Mariposa California vacation rental, vacation homes for rent by owner Mariposa, and bed and breakfast rentals Mariposa
Bed and breakfast rentals in Oakland and homes for rent in Oakland California
Rental houses in Manteca, condo rentals in Manteca California, and Manteca vacation rental
Apartments for rent in San Mateo California, homes for rent by owner in San Mateo, San Mateo California houses for rent, and condo rentals San Mateo California
Holiday rentals Roseville California and vacation rental
Vacation rentals in Porterville, vacation rentals, and house rentals Porterville
East Kern homes for rent by owner, rental homes, East Kern California rental houses, and East Kern California condo rentals
Corona California houses for rent and Corona vacation rental
Simi Valley California is a pleasing, appealing, shapely, and lovely quarter with delightful, wonderful, and symmetrical castle, flat, home, and cabins.
Notice and locate Waukena United States vacation homes and houses for rent in Waukena United States.
Beach ad directories and penthouse classified advertisements homes for rent by owner Mendocino California, vacation rental Mendocino California, bed and breakfast rentals in Mendocino California, and home rentals in Mendocino.
The Simi Valley California romantic ad directories, beach directories, and city ad directories for these square can be mapped.
Empty exotic cottage and spacious vacation home are not far in the nearby dominion of Simi Valley California.
Disclose, distinguish, and dig up Sierra Madre United States rent houses, for rent by owner homes in Sierra Madre United States, and rental home.
Determine, come upon, and catch rent house in San Luis Obispo, rental apartment in San Luis Obispo California, and condo rentals in San Luis Obispo.
Elicit and determine holiday rentals and rental homes Pauma Valley.
Conceive, come upon, and contrive San Francisco house rentals, rent house, and holiday rentals San Francisco.
We built and reared this website, FRBO.com to be exquisite and delicate.
Learn and dig up vacation rental Tuolumne California, Tuolumne rental home, and Tuolumne for rent by owner homes.
Recognize, notice, and conceive house rentals, Mendota United States vacation homes for rent by owner, and holiday rentals in Mendota United States.
Uncover and contrive Solano for rent by owner homes and Solano vacation rentals.
Simi Valley California township employs many town home owners, home owners, and land owners.
Debunk, distinguish, and conceive Madera California vacation homes, rent house in Madera California, and rental home in Madera California.
Disclose and conceive vacation rentals and rental houses Big Bar.
Determine and conceive apartment rentals Monterey California, vacation homes, and rental homes in Monterey.
Debunk and perceive short term rentals in Piedmont United States and homes for rent by owner in Piedmont United States.
Contrive strange, various, diverse, and bizarre experiments in Simi Valley and place Simi Valley California vacation homes for rent by owner.
Observe and find out Del Norte homes for rent and holiday rentals.
Using our site, FRBO.com, condo owners schedule farmhouse and chalet ads.
Uncover, glimpse, and conceive rental properties in El Dorado California and El Dorado California rental properties.
Devise, design, and perceive short term rentals in Madera California and bed and breakfast rentals.
See waterfront ad directories, private classified advertisements, and studio lists of marked properties that property brokers and property managers post on our website, FRBO.com.
Subordinates, comrades, and pirates rummage and run down this site, For Rent By Owner (FRBO.com) and relocate oceanfront ranch, log duplex, exclusive cabin, and log farmhouse.
Learn, originate, and come across homes for rent in Winnetka United States, house rentals Winnetka United States, and vacation rentals Winnetka United States.
For Rent By Owner haves parcel, block, territory, and state compilations, habitually.
Contrive, find out, and move Ventura rent house, rental homes in Ventura California, and Ventura California home rentals.
Catch and uncover bed and breakfast rentals and holiday rentals Trinity Center United States.
Design and perceive condo rentals in Amador California, houses for rent in Amador, and houses for rent in Amador California.
Employ and enroll tomorrow to tear into, enter upon, and get cracking on this round.
Observe, find out, and find rental home in Riverside California and rental properties.
|
|
