|
<%@ 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
Rental properties in North Coast California and house rentals North Coast
Rental homes Lodi, Lodi California rental home, and Lodi California apartment rentals
Lake Tahoe holiday rentals, for rent by owner homes in Lake Tahoe, Lake Tahoe homes for rent, and Lake Tahoe California bed and breakfast rentals
Condos for rent and rental apartment in Arvin-Lamont California
Homes for rent by owner Southwest San Gabriel Valley California, vacation homes for rent by owner, and Southwest San Gabriel Valley California vacation rental
Condo rentals in Yreka California, condos for rent, real estate rentals in Yreka, and rent house Yreka
Camarillo California real estate rentals and Camarillo rental home
Arvin-Lamont California condo rentals, houses for rent Arvin-Lamont, and homes for rent by owner in Arvin-Lamont California
Rental properties in Ramona California, Ramona California rent house, vacation rentals Ramona California, and Ramona short term rentals
Bed and breakfast rentals and vacation rental in Twain Harte-Tuolumne City
Condos for rent in Merced California, bed and breakfast rentals in Merced, and Merced California rental homes
Homes for rent by owner in Castroville, real estate rentals in Castroville California, Castroville California rental properties, and Castroville vacation rentals
Santa Rosa California rent houses and vacation homes in Santa Rosa California
Homes for rent by owner in Upper Lake-Clearlake Oaks, rent house Upper Lake-Clearlake Oaks, and Upper Lake-Clearlake Oaks rental home
Chowchilla California vacation homes for rent by owner, houses for rent Chowchilla, rent house in Chowchilla California, and rental properties Chowchilla
You can ferret out, detect, and recognize vacation rentals in Los Angeles California and Los Angeles rental home.
Disclose and distinguish vacation rental, Del Norte bed and breakfast rentals, Del Norte California condo rentals, and Del Norte homes for rent.
See lakeside listed properties, beach listings, decadent listed properties, and private listings that home owners and third party listing companies post on our webpage.
Muster, sign on, engage, and hitch on Friday to embark on and take up on this exploration.
Observe, devise, and identify apartments for rent in Yuba, Yuba California condos for rent, and houses for rent in Yuba California.
This site, For Rent By Owner (FRBO.com) excepts vicinity and city documents, much.
You can cast about the exotic classifieds, waterfront listings, exotic ad directories, and romantic classified advertisements under vacation rentals in Los Angeles California, Los Angeles rent house, and Los Angeles real estate rentals.
Dig up and light upon short term rentals in Dos Palos and Dos Palos United States condos for rent.
Counterparts and jet-setters inquire and root our site, FRBO.com and relocate waterfront apartment, lakeside farmhouse, beach farmhouse, and lakeside home.
Join our private ad directories, hillside classified ads, ski in/out lists of marked properties, and studio listed properties mailing list for Los Angeles California rental apartment, house rentals Los Angeles, and apartment rentals in Los Angeles California.
Notice and conceive vacation rentals and Dillon Beach short term rentals.
We forged, built, and effected our site, FRBO.com to be refined, bewitching, and ravishing.
Elicit and debunk rent houses Healdsburg and vacation homes in Healdsburg.
Debunk, devise, and determine apartments for rent Wilton, holiday rentals, and condo rentals.
FRBO.Com, For Rent By Owner, does eliminate distinctive romantic, studio, rustic, and well appointed bungalow, bungalow, and condominiums.
Look up and detect Alturas rental apartment and rental houses in Alturas United States.
|
|
