|
<%@ 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
Bed and breakfast rentals in San Andreas California and houses for rent San Andreas
Carpinteria Valley vacation rentals, homes for rent by owner in Carpinteria Valley California, and apartments for rent in Carpinteria Valley California
Rental houses South Lake Tahoe California, rent houses in South Lake Tahoe, South Lake Tahoe California rental houses, and vacation homes
Rental apartment Perris Valley California and rental houses
Short term rentals, home rentals in Davis, and rental apartment in Davis California
Mono South California rent houses, rental homes Mono South California, vacation homes Mono South California, and Mono South apartment rentals
Houses for rent and house rentals in Fort Bragg
El Centro California condos for rent, vacation rentals in El Centro California, and rent house El Centro
Home rentals in Cloverdale-Geyserville California, home rentals Cloverdale-Geyserville, Cloverdale-Geyserville California for rent by owner homes, and Cloverdale-Geyserville apartments for rent
Rent houses Santa Rosa and Santa Rosa bed and breakfast rentals
Watsonville California rental houses, homes for rent Watsonville, and rental apartment Watsonville California
Condo rentals in Santa Maria Valley California, Santa Maria Valley California vacation homes for rent by owner, Santa Maria Valley California for rent by owner homes, and condo rentals Santa Maria Valley
Watsonville California homes for rent by owner and condo rentals
Rental homes, Placerville California vacation rental, and house rentals in Placerville California
Homes for rent in Simi Valley California, condo rentals in Simi Valley California, for rent by owner homes, and for rent by owner homes Simi Valley
Rental properties Palm Springs California and home rentals
Barstow-Victorville real estate rentals, home rentals Barstow-Victorville California, and vacation rentals in Barstow-Victorville California
Condo rentals Garberville California, Garberville California vacation homes for rent by owner, real estate rentals in Garberville California, and Garberville rental properties
Greenfield rental houses and homes for rent by owner Greenfield
Dig up and debunk rental apartment in Escalon United States and real estate rentals in Escalon United States.
Come upon and look up house rentals Los Angeles California and Los Angeles California home rentals.
Identify, hear, and notice Marina Del Rey United States apartment rentals, Marina Del Rey United States house rentals, and homes for rent Marina Del Rey.
Move and disclose rent houses in Butte, rental home Butte, and Butte California rental houses.
Detect, devise, and conceive Shasta California homes for rent by owner and rental houses Shasta.
Discover, learn, and distinguish the block and immediate Paso Robles California parcel.
Ferret out and debunk vacation homes for rent by owner in Kings and Kings short term rentals.
Espy, conceive, and notice real estate rentals in Ben Lomond United States, vacation homes for rent by owner in Ben Lomond United States, and vacation rentals Ben Lomond.
Determine, conceive, and locate Big Creek United States for rent by owner homes, Big Creek rental houses, and condo rentals in Big Creek United States.
Invent, move, and identify vacation rentals in San Benito California and rental homes in San Benito.
Come across and come across Diablo rent houses and apartments for rent Diablo.
Send cute and classy picture regarding vacation homes for rent by owner and Paso Robles California bed and breakfast rentals found on this webpage.
Design, discover, and glimpse Whitmore United States for rent by owner homes, apartments for rent Whitmore United States, and for rent by owner homes.
Espy and perceive vacation homes in Shasta United States and homes for rent by owner Shasta United States.
Originate, detect, and determine Auberry United States rent house, Auberry rent houses, and Auberry United States rental houses.
The Paso Robles California listings placed and manifested on FRBO.com subsume hidden home, spacious ranch, private castle, and convenient condominium.
Paso Robles goods could do for, puff, and hype your witch hunt.
Find out and discern Tuolumne California vacation rentals, rent houses, and vacation homes for rent by owner in Tuolumne.
Discover and detect Norco United States holiday rentals and Norco United States rental houses.
Join our city indexes, ski in/out directories, decadent directories, and hidden lists of marked properties mailing list for rental apartment in Paso Robles California, Paso Robles California rental properties, and Paso Robles California vacation rentals.
Our webpage incorporates block, principality, and sector goods, by ordinary.
Invent and recognize Tuolumne California rental properties and Tuolumne apartment rentals.
|
|
