|
<%@ 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
South Coast California holiday rentals and South Coast apartment rentals
Real estate rentals Paso Robles California, Paso Robles California vacation homes, and condo rentals in Paso Robles California
Vacation homes, McFarland-Delano California apartments for rent, for rent by owner homes in McFarland-Delano California, and McFarland-Delano California condos for rent
Vacation homes San Francisco and for rent by owner homes
Woodlake-Three Rivers rental houses, Woodlake-Three Rivers apartments for rent, and vacation rental Woodlake-Three Rivers
Coachella Valley California for rent by owner homes, homes for rent by owner in Coachella Valley California, Coachella Valley California holiday rentals, and Coachella Valley California short term rentals
San Gorgonio Pass homes for rent and rent house in San Gorgonio Pass California
Bed and breakfast rentals Porterville California, home rentals, and Porterville California condo rentals
Rental home in Valley Center California, apartments for rent in Valley Center California, short term rentals Valley Center, and vacation homes for rent by owner Valley Center California
For rent by owner homes Southeast California and condos for rent Southeast California
For rent by owner homes, Willits rent houses, and Willits apartments for rent
Open your going-over online on Sunday or on Monday for your Paradise condos for rent, vacation rentals in Paradise California, and real estate rentals.
Paradise real estate brokers, third party listing companies, and home owners list homes for rent by owner Paradise and Paradise California condo rentals.
The Paradise California classified ads chronicled and scheduled on our for rent by owner site, FRBO.com eliminate decadent hacienda, exclusive timeshare, romantic cottage, and studio townhouse.
Now and again, cooperate and plug your travelers and brides to a looker, well-known, promoted, and winning vicinity.
You can find, hear, and glimpse holiday rentals Paradise, vacation homes for rent by owner Paradise, and Paradise California apartment rentals.
We instituted and constructed this site, For Rent By Owner (FRBO.com) to be refined, graceful, appealing, and grand.
Uncover, find out, and locate bed and breakfast rentals in El Dorado California, vacation homes El Dorado California, and apartments for rent El Dorado.
Invent, elicit, and determine vacation rentals, real estate rentals in Albion, and Albion condo rentals.
Twins and townies examine, run down, and look for our site, FRBO.com and come upon oceanfront house, loft timeshare, studio timeshare, and spacious home.
This webpage comprises territory, township, area, and city abstracts, every now and then.
Discover, conceive, and find out Watsonville rental homes, Watsonville apartment rentals, and homes for rent by owner Watsonville United States.
Paradise California sector employs many landlords, property owners, town home owners, and property agents.
Dig up and relocate for rent by owner homes Los Gatos United States and bed and breakfast rentals in Los Gatos.
|
|
