|
<%@ 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
Holiday rentals South Lake Tahoe and South Lake Tahoe California vacation homes
Apartments for rent in Hayward California, rental home Hayward, and apartment rentals in Hayward
Chuckwalla California rental apartment, Chuckwalla California condo rentals, Chuckwalla California vacation homes for rent by owner, and Chuckwalla California vacation rentals
Alameda California apartment rentals and Alameda California home rentals
Tehachapi homes for rent by owner, Tehachapi vacation homes for rent by owner, and house rentals in Tehachapi California
For rent by owner homes East Yolo California, East Yolo houses for rent, rental properties in East Yolo California, and holiday rentals in East Yolo California
Hayward for rent by owner homes and rental homes in Hayward California
Holiday rentals in Murrieta California, Murrieta California vacation rental, and vacation rental Murrieta California
Livingston-Delhi real estate rentals, vacation rental in Livingston-Delhi, Livingston-Delhi California vacation rental, and Livingston-Delhi California homes for rent by owner
Avenal California rent houses and homes for rent by owner in Avenal California
Houses for rent in Livingston-Delhi California, Livingston-Delhi California rental homes, and rental homes in Livingston-Delhi
Apartment rentals in Calipatria-Westmorland California, apartments for rent in Calipatria-Westmorland California, houses for rent Calipatria-Westmorland California, and rent house Calipatria-Westmorland California
Burbank vacation homes and rent houses in Burbank California
Rental home in Tracy California, bed and breakfast rentals in Tracy California, and rental home in Tracy California
Vacation homes for rent by owner in Angels City California, Angels City California vacation rentals, house rentals Angels City California, and Angels City rental houses
Short term rentals in Lindsay and Lindsay homes for rent by owner
Ukiah California rent houses, home rentals in Ukiah, and Ukiah home rentals
Vacation homes Murrieta California, home rentals in Murrieta California, rental apartment in Murrieta California, and rental houses in Murrieta California
Detect and design Calaveras California vacation rental and rental properties.
Notice, devise, and locate Colusa California rental home, Colusa vacation homes for rent by owner, bed and breakfast rentals, and Colusa for rent by owner homes.
Glimpse and espy vacation rental Morgan Hill United States and home rentals in Morgan Hill.
Willows abstracts could sustain, further, and aid your perquisition.
Debunk, distinguish, and uncover Los Angeles California vacation rentals and Los Angeles rental properties.
Learn and uncover vacation homes for rent by owner in Big Bear City United States and condo rentals.
You can light upon and relocate Willows vacation rental, rental properties in Willows, and homes for rent.
Locals, residers, and twins who are rooting Willows vacation rentals and are trying to find Willows home rentals and condos for rent Willows California can investigate our webpage and our city directories, rustic classified ads, secluded classified ads, and oceanfront classified ads.
Our online website, FRBO.com does comprehend express turf hidden, ski in/out, private, and private home, duplex, and timeshares.
Invent and move Junction City rental properties and apartments for rent.
FRBO.Com, For Rent By Owner, can serve, record, and secure suburban classified advertisements, spacious classified ads, and exotic online MLS beachfront classified advertisements, suburban classifieds, loft listings, and suburban lists of marked properties to facilitate your Willows hike.
Notice, catch, and devise Nevada vacation rentals, home rentals Nevada, homes for rent in Nevada California, and Nevada California rental apartment.
The Willows California indexes manifested and buttoned down on For Rent By Owner consist of suburban duplex, oceanfront townhouse, hillside castle, and log home.
Devise and recognize vacation homes for rent by owner in Sutter California and rental apartment in Sutter California.
Ski in/out classified advertisements and suburban classified advertisements Sonoma apartments for rent, rental houses in Sonoma California, Sonoma California rental houses, and condo rentals in Sonoma California.
Recognize, identify, and explore Nevada California home rentals, Nevada California rental apartment, and Nevada California houses for rent.
Determine and learn bed and breakfast rentals in Trinity California, Trinity California short term rentals, and home rentals.
Distinguish and identify rental houses Los Angeles and homes for rent by owner Los Angeles California.
Hear, discern, and conceive vacation homes in Imperial, Imperial California home rentals, and houses for rent.
Light upon, espy, and recognize the field and near-at-hand Willows square.
Identify and discern Merced rental home, rent houses in Merced, and Merced California rental houses.
|
|
