|
<%@ 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
Short term rentals in Redwood-Potter California and rental properties Redwood-Potter California
Rental homes El Centro California, El Centro condos for rent, and vacation rentals El Centro California
Vacation rentals in Healdsburg, rental properties Healdsburg, rent house in Healdsburg California, and rental properties
Rent house in Fresno and Fresno California rental houses
Rent houses, holiday rentals, and house rentals Placerville California
Watsonville California rent house, Watsonville California holiday rentals, Watsonville California homes for rent, and rent house Watsonville California
Vacation rental in Glendale California and vacation rentals in Glendale
Homes for rent by owner Fresno, vacation homes Fresno, and condo rentals in Fresno California
Vacation homes in Twain Harte-Tuolumne City, homes for rent by owner Twain Harte-Tuolumne City California, apartment rentals, and houses for rent
Rental houses Visalia and vacation homes for rent by owner in Visalia
Vacation rental in Elk Grove, Elk Grove California rental homes, and rental properties in Elk Grove California
Homes for rent in Sonora, house rentals, Sonora California vacation rentals, and bed and breakfast rentals Sonora California
Originate and discover Lassen California rental apartment and Lassen California rental properties.
For Rent By Owner can engage and recruit private listed properties, resort advertisements, and well appointed advertisements loft classified advertisements, mountain listed properties, well appointed classifieds, and mountain listings to ballyhoo your Santa Ynez Valley California tramp.
Using our webpage, landlords catalogue home and houseboat lists of marked properties.
Our for rent by owner website does involve diverse city spacious and lakefront townhouse, house, and haciendas.
You can rummage the beach listed properties, lakefront directories, and studio classified advertisements under Santa Ynez Valley condos for rent and home rentals Santa Ynez Valley.
Our site, FRBO.com embraces county, territory, square, and area circumstances, often enough.
Come upon and perceive rental homes and houses for rent in June Lake.
Santa Ynez Valley property owners and town home owners list Santa Ynez Valley rental home, vacation homes for rent by owner Santa Ynez Valley, and Santa Ynez Valley California vacation rentals.
Hitch and muster tonight to inaugurate, originate, begin, and launch on this wandering.
Hear, identify, and discover condo rentals Tuolumne California and Tuolumne California bed and breakfast rentals.
The Santa Ynez Valley California hidden advertisements and waterfront advertisements for these zone can be mapped.
Send well-formed and fine reports regarding Santa Ynez Valley rent houses, rental properties, Santa Ynez Valley California homes for rent by owner, and Santa Ynez Valley California condo rentals found on this site, For Rent By Owner (FRBO.com).
The Santa Ynez Valley advertisements invoiced and kept counted on our for rent by owner website eliminate convenient farmhouse, studio ranch, well appointed houseboat, and hillside cabin.
|
|
