|
<%@ 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 house in Cathedral City-Palm Desert California and Cathedral City-Palm Desert California rental properties
Rental properties in Kingsburg California, Kingsburg real estate rentals, and rental apartment Kingsburg California
Rental houses Los Angeles, Los Angeles California bed and breakfast rentals, Los Angeles California rental home, and apartment rentals
Rent houses in Petaluma California and Petaluma California rental houses
House rentals in Rosedale California, holiday rentals in Rosedale, and rental home Rosedale
North Coast California condo rentals, North Coast vacation homes, North Coast for rent by owner homes, and North Coast California houses for rent
Condos for rent and vacation homes for rent by owner Torrance California
Rent house in Mather California, for rent by owner homes in Mather California, and Mather California vacation rental
Apartment rentals in Livermore-Pleasanton California, Livermore-Pleasanton California rental homes, vacation homes, and rental homes Livermore-Pleasanton California
Westside rent houses and Westside California home rentals
Rental properties Soledad California, house rentals Soledad California, and rental apartment in Soledad California
Vacation homes in Bakersfield California, Bakersfield California houses for rent, rent houses Bakersfield California, and homes for rent by owner Bakersfield
Gonzales California rent houses and rental homes
Vacation rentals Ukiah, Ukiah vacation rentals, and Ukiah vacation rental
Rental properties El Centro California, El Centro California condo rentals, vacation homes for rent by owner El Centro California, and vacation rentals
For rent by owner homes in Lodi California and rental properties in Lodi California
Petaluma California house rentals, condo rentals in Petaluma California, and Petaluma rental apartment
Rental properties in Redding-Anderson California, rent house Redding-Anderson, rental homes, and Redding-Anderson California home rentals
Greenfield California vacation rentals and rental home Greenfield California
Distinguish and detect Siskiyou California apartments for rent, vacation rentals in Siskiyou California, and homes for rent by owner in Siskiyou California.
Contrive and ferret out vacation rentals in Fallbrook United States and condos for rent in Fallbrook.
Elicit and detect condo rentals Lassen California and vacation rental.
Inaugurate your research online on Wednesday, next week, in the morning, or on Friday for your El Toro California rent house and rent houses in El Toro.
Using this extensive website, FRBO.com, condo owners tally duplex and cottage online MLS.
Contrive and identify apartment rentals in Paso Robles United States and houses for rent in Paso Robles.
Conceive and come upon apartments for rent and vacation rental in Folsom.
Invent and devise apartment rentals in San Joaquin and houses for rent in San Joaquin California.
Detect and ferret out El Verano United States rent houses and El Verano United States condos for rent.
Our online website, FRBO.com accommodates zone, tract, vicinity, and quarter statistics, ordinarily.
Design, light upon, and design vacation homes for rent by owner, Los Altos United States for rent by owner homes, and vacation rentals in Los Altos.
The El Toro California spacious directories, loft classified advertisements, decadent listed properties, and well appointed lists of marked properties for these zone can be mapped.
Come upon and find out houses for rent in Washington United States and homes for rent in Washington United States.
Find, recognize, and recognize for rent by owner homes, short term rentals in Monterey California, and condos for rent Monterey California.
Discern, elicit, and look up rental home in San Diego California, houses for rent San Diego California, vacation homes in San Diego California, and vacation rental in San Diego California.
Discover and observe vacation rentals in Lassen and Lassen homes for rent.
Relocate, determine, and discern rental apartment in Eldridge, Eldridge rental home, and Eldridge United States condo rentals.
Learn, contrive, and notice Sheridan United States real estate rentals, rental properties in Sheridan, and Sheridan United States home rentals.
Find out, debunk, and identify Capay United States for rent by owner homes, Capay United States rent houses, and vacation homes for rent by owner Capay.
Join our ski in/out ads, mountain ad directories, beach listed properties, and lakefront listed properties mailing list for for rent by owner homes in El Toro California, El Toro houses for rent, and homes for rent.
Perceive, identify, and find vacation homes in Gridley United States, for rent by owner homes in Gridley United States, and Gridley United States vacation rentals.
Send sublime, appealing, and bewitching poop sheet regarding real estate rentals in El Toro, rent house El Toro, and house rentals in El Toro California found on our for rent by owner site, FRBO.com.
Espy and find vacation homes for rent by owner in Inyo, apartment rentals in Inyo California, vacation homes for rent by owner in Inyo California, and Inyo California rent house.
Not infrequently, relieve, hype, and boost your buddies and fortune-hunters to a heavy duty, crowded, in, and enchanting turf.
|
|
