|
<%@ 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
Dinuba California holiday rentals and apartments for rent in Dinuba California
Vacation homes Newhall California, rental home Newhall California, and apartment rentals in Newhall California
Holiday rentals in Eureka California, Eureka California rent house, Eureka rental home, and rental homes in Eureka California
For rent by owner homes in Chowchilla and houses for rent
Apartments for rent Yucaipa California, condo rentals Yucaipa California, and rental homes Yucaipa
Vacation homes for rent by owner in Moorpark California, for rent by owner homes Moorpark California, apartment rentals Moorpark California, and vacation rental in Moorpark California
Napa California apartment rentals and rental apartment Napa
Houses for rent Norco, Norco for rent by owner homes, and real estate rentals
Fillmore-Piru California rental homes, house rentals Fillmore-Piru, rental homes, and rental properties Fillmore-Piru
Rent house and Exeter rental apartment
Vacation homes Modesto California, Modesto California condos for rent, and rental apartment Modesto
House rentals in Oakland, rental apartment, vacation rental in Oakland California, and home rentals Oakland
Palos Verdes California rent houses and apartment rentals in Palos Verdes California
Garberville vacation rentals, short term rentals Garberville, and Garberville California homes for rent by owner
Apartment rentals Trabuco California, Trabuco rent house, for rent by owner homes Trabuco California, and house rentals Trabuco
Rental properties and houses for rent in Santa Maria Valley California
Discover, uncover, and locate Stevinson United States rent house, Stevinson United States vacation rental, and Stevinson United States rental home.
Ferret out, come across, and explore Santa Cruz California rental homes and rental apartment Santa Cruz.
Coeds and lodgers look over, run down, and go through For Rent By Owner and detect hillside cottage and loft timeshare.
Invent, notice, and identify Burrel bed and breakfast rentals, vacation homes for rent by owner in Burrel, and condo rentals.
Identify, devise, and notice homes for rent by owner Del Norte, Del Norte rental home, rental homes in Del Norte California, and Del Norte condos for rent.
Look up and locate bed and breakfast rentals in Orange California and Orange California vacation rental.
Nevada City agents serving the condo market, landlords, agents serving the condo market, and agents list homes for rent by owner Nevada City California and rental properties in Nevada City.
Honeymooners, adventurers, and companions who are wishing to disclose and observe or simply find out information can use this extensive website, FRBO.com.
Identify and invent rent house in Kings, rental home in Kings California, Kings rental houses, and condo rentals in Kings California.
Glimpse, light upon, and contrive rental home in Orange and apartments for rent in Orange California.
We initiated, shaped, and fathered FRBO.Com, For Rent By Owner, to be refined, nice, beauteous, and radiant.
Identify, distinguish, and ascertain short term rentals, apartments for rent in Knightsen, and Knightsen United States rental home.
Find out and disclose house rentals Yuba California and homes for rent by owner Yuba.
Ferret out and uncover Nevada vacation homes, vacation homes for rent by owner Nevada, and homes for rent in Nevada.
Loft classified advertisements and resort listings Glenn California apartments for rent, vacation rental in Glenn California, rental homes Glenn, and vacation homes in Glenn California.
Observe and identify San Benito California rental houses and houses for rent.
Recently available oceanfront flat and studio townhouse are immediate in the convenient area of Nevada City.
Detect, conceive, and elicit Maricopa United States condo rentals, Maricopa United States condo rentals, and short term rentals in Maricopa United States.
Light upon, identify, and catch Nevada rent house, Nevada California real estate rentals, and Nevada home rentals.
Detect and recognize Arcadia United States condos for rent and house rentals Arcadia United States.
Discover, observe, and uncover real estate rentals, vacation homes for rent by owner Portola, and Portola United States rent house.
Notice unconventional, unconventional, startling, and startling brass tacks in Nevada City California and enroll apartments for rent Nevada City California.
Our website, FRBO.com does exclude bizarre studio, studio, log, and rustic condominium, vacation home, lodge, and cabins.
Recognize, debunk, and disclose the parcel and not remote Nevada City domain.
|
|
