|
<%@ 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
Newhall vacation rental and Newhall California vacation homes
Rental home Shafter California, apartments for rent Shafter, and Shafter home rentals
Hemet-San Jacinto California homes for rent by owner, Hemet-San Jacinto California homes for rent by owner, apartment rentals, and apartments for rent Hemet-San Jacinto California
Holiday rentals Russian River-Coastal California and rent house in Russian River-Coastal
Twain Harte-Tuolumne City rental apartment, rental houses Twain Harte-Tuolumne City California, and Twain Harte-Tuolumne City California apartment rentals
San Lorenzo Valley California vacation rental, rent house, San Lorenzo Valley California rental apartment, and vacation rental in San Lorenzo Valley
Short term rentals Yreka and condos for rent in Yreka California
Condo rentals Santa Cruz California, home rentals Santa Cruz California, and Santa Cruz vacation homes for rent by owner
South Lake Tahoe California rental homes, South Lake Tahoe California rental homes, for rent by owner homes South Lake Tahoe California, and rental home in South Lake Tahoe
Vacation homes in East Contra Costa California and apartments for rent in East Contra Costa California
Rental apartment in Yucaipa California, home rentals in Yucaipa, and Yucaipa California condo rentals
Rental apartment in Waterford, homes for rent by owner in Waterford California, rental houses in Waterford California, and Waterford California apartment rentals
Moorpark vacation homes for rent by owner and Moorpark vacation rentals
Vacation homes, Berkeley California homes for rent by owner, and home rentals in Berkeley
Vacation homes for rent by owner in Escalon California, rental homes Escalon, rental homes in Escalon California, and Escalon California apartments for rent
Condo rentals in North Coast California and North Coast California rent house
The Vacaville California rustic listings and exclusive ad directories for these can be mapped.
See convenient classifieds, lake directories, beach classifieds, and beach lists of marked properties that real estate brokers and rental property owners post on this site, For Rent By Owner (FRBO.com).
Disclose, move, and discern San Luis Obispo California vacation rental, condos for rent in San Luis Obispo California, San Luis Obispo California homes for rent, and vacation homes for rent by owner San Luis Obispo California.
Dig up and determine real estate rentals in Loma Linda and condos for rent.
Determine, identify, and find out vacation homes for rent by owner and Humboldt California real estate rentals.
Locate, recognize, and find out vacation homes for rent by owner in Santa Fe Springs United States, vacation rental Santa Fe Springs, and Santa Fe Springs home rentals.
This site, For Rent By Owner (FRBO.com) can obtain, gather, recruit, and reserve decadent listings, oceanfront ads, well appointed online MLS, and studio listings waterfront classified advertisements and beach directories to help your Vacaville California jaunt.
Locate, design, and disclose vacation rental in Deer Park United States, rental home in Deer Park United States, and Deer Park United States apartments for rent.
Gather and obtain this weekend to launch and inaugurate on this sally.
Vacaville landlords and third party listing companies list rental home in Vacaville California and rental properties in Vacaville California.
Find out, originate, and uncover vacation homes for rent by owner in Sierra California and Sierra California holiday rentals.
Debunk and elicit Inyo rental homes, rent houses, rental houses in Inyo, and rent house Inyo California.
Contrive, come across, and ferret out bed and breakfast rentals in Santa Cruz California, condos for rent, and rental houses in Santa Cruz.
Move and explore apartment rentals Nevada and apartments for rent in Nevada California.
Look up, ascertain, and discover rental houses Santa Clara California, vacation rentals Santa Clara California, and rental home.
Ready to move in convenient hacienda and rustic ranch are not remote in the adjoining sector of Vacaville.
Come upon, find out, and explore vacation rentals Weldon, apartment rentals in Weldon United States, and condos for rent in Weldon.
This site, FRBO.com does except unusual private and beach townhouse, farmhouse, and apartments.
Dig up and design Atascadero vacation rentals and homes for rent by owner in Atascadero.
Vacaville California is a cute and handsome neighborhood with good-looking and splendid bungalow, home, and cottages.
Recognize, devise, and notice holiday rentals Alhambra United States, Alhambra United States apartments for rent, and bed and breakfast rentals in Alhambra United States.
|
|
