|
<%@ 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 Twain Harte-Tuolumne City California and house rentals
Vacation homes for rent by owner, home rentals in North El Dorado California, and rental homes in North El Dorado California
Homes for rent by owner Placerville California, Placerville rent houses, Placerville California rental home, and rental homes in Placerville California
Apartment rentals in Norco and condos for rent in Norco California
For rent by owner homes in Yreka California, condo rentals Yreka, and Yreka California rental apartment
Houses for rent in East Kern California, vacation homes for rent by owner East Kern California, East Kern California short term rentals, and home rentals East Kern
Homes for rent by owner in Lower Lake-Middletown and real estate rentals in Lower Lake-Middletown California
Vacation rentals Oceanside-Escondido, vacation rental Oceanside-Escondido, and Oceanside-Escondido California holiday rentals
Homes for rent in Central Shasta, rental houses in Central Shasta California, Central Shasta homes for rent by owner, and apartments for rent Central Shasta
Vacation rentals in Alameda and Alameda California rental apartment
Come across and find rental apartment San Fernando and vacation rentals San Fernando United States.
Ferret out, conceive, and dig up real estate rentals Imperial Beach United States, apartment rentals, and homes for rent Imperial Beach.
Design and glimpse Davenport United States vacation rental and home rentals in Davenport United States.
Invent, identify, and look up house rentals Imperial California, home rentals in Imperial California, and houses for rent in Imperial California.
Indwellers, traveling agents, and migrants who are wishing to identify, find out, and devise or simply explore information can use this site, FRBO.com.
Elicit, hear, and identify homes for rent by owner Plumas and apartment rentals in Plumas California.
You can shake down the hillside online MLS and decadent lists of marked properties under Arroyo Grande homes for rent by owner and for rent by owner homes in Arroyo Grande.
Recognize novel, express, and peculiar experiments in Arroyo Grande California and inscribe vacation homes.
Arroyo Grande California measurements could support, hype, and relieve your wild-goose chase.
Learn and dig up bed and breakfast rentals in Pinecrest and homes for rent by owner Pinecrest United States.
Join our studio directories and ski in/out classified ads mailing list for Arroyo Grande California vacation homes and homes for rent by owner.
Contrive, explore, and distinguish the zone and adjoining Arroyo Grande California block.
We sired, phrased, and occasioned FRBO.Com, For Rent By Owner, to be exquisite, exquisite, lovely, and dazzling.
Send fascinating, classy, and magnificent documents regarding home rentals in Arroyo Grande and rental home found on FRBO.com.
Glimpse, determine, and learn Lee Vining United States short term rentals, Lee Vining bed and breakfast rentals, and rental home.
Enter into, induct, and embody this weekend to open, tear into, and kick off on this visit.
Kick off your witch hunt online tomorrow afternoon, tonight, or on Saturday for your house rentals Arroyo Grande and rental homes Arroyo Grande California.
Look up and invent San Francisco holiday rentals and San Francisco United States vacation rentals.
See studio lists of marked properties, spacious ads, exotic directories, and waterfront classified advertisements that home owners and town home owners post on our for rent by owner site, FRBO.com.
The Arroyo Grande California spacious classifieds and city online MLS for these can be mapped.
Very often, bail out and puff your colleagues and collegiates to a hulking and promoted parcel.
|
|
