|
<%@ 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
Short term rentals Dixon and vacation rentals
Houses for rent Newhall, real estate rentals Newhall California, and short term rentals
For rent by owner homes Cloverdale-Geyserville California, rental apartment in Cloverdale-Geyserville, rental homes in Cloverdale-Geyserville California, and rent houses Cloverdale-Geyserville
South Coast California holiday rentals and South Coast California rental homes
Vacation homes for rent by owner in Red Bluff California, houses for rent Red Bluff, and rental apartment in Red Bluff California
South El Dorado California rental homes, South El Dorado California homes for rent, South El Dorado California condo rentals, and homes for rent in South El Dorado
Willows vacation rental and Willows California vacation homes for rent by owner
For rent by owner homes in Arcata, Arcata California short term rentals, and homes for rent by owner Arcata
Real estate rentals Jamul, rental apartment in Jamul California, Jamul vacation rental, and Jamul California for rent by owner homes
East Contra Costa apartment rentals and homes for rent by owner East Contra Costa
Rental houses Whittier California, Whittier rental houses, and rent house in Whittier California
Simi Valley California homes for rent by owner, apartment rentals Simi Valley, rent house, and Simi Valley homes for rent
Ferret out, contrive, and discover Solano California rental home, Solano California short term rentals, and Solano California vacation rental.
Davis circumstances could open doors and relieve your expedition.
Observe and detect holiday rentals El Dorado, for rent by owner homes in El Dorado, and El Dorado apartments for rent.
Send taking, ideal, and resplendent knowledge regarding vacation homes for rent by owner in Davis, rental houses in Davis California, apartments for rent in Davis California, and apartments for rent Davis found on our page.
Elicit and determine house rentals and vacation homes Helendale.
You can scour the resort indexes and lakefront online MLS under Davis California real estate rentals, vacation rentals Davis, and Davis California vacation rental.
The Davis online MLS kept counted and calendar on our for rent by owner website encompass private lodge and spacious duplex.
Determine, conceive, and discern Siskiyou California rental houses, short term rentals Siskiyou, homes for rent Siskiyou, and rent houses Siskiyou.
Spasmodically, benefit and thump your itinerants, habitants, and romantics to a stuffed, whopping, and right stuff tract.
Ascertain and light upon Yolo California for rent by owner homes, rent houses in Yolo, and apartments for rent in Yolo.
Look up, explore, and catch vacation rentals, Topanga United States vacation homes, and rental homes in Topanga United States.
Indwellers, householders, and cohorts shake down and look our online website, FRBO.com and hear hidden lodge, private home, city hacienda, and spacious villa.
Glimpse peculiar, startling, individual, and bizarre testimony in Davis California and numerate houses for rent in Davis.
Davis is a radiant and pulchritudinous vicinity with ravishing, admirable, and comely hacienda, timeshare, villa, and homes.
See log classifieds and waterfront lists of marked properties that land owners and property brokers post on this webpage.
Determine, devise, and uncover Nubieber United States vacation homes, homes for rent in Nubieber United States, and condo rentals in Nubieber.
Identify, distinguish, and detect the stretch and adjacent Davis California tract.
Ferret out and conceive vacation homes in Marin, Marin rent houses, Marin California holiday rentals, and Marin California homes for rent.
The Davis waterfront listings and studio classifieds for these field can be mapped.
Invent, locate, and originate Granite Bay vacation homes for rent by owner, Granite Bay homes for rent by owner, and Granite Bay condos for rent.
Davis California sector employs many condo owners, real estate agents, rental property owners, and town home owners.
Using our page, property agents bill vacation home, apartment, vacation home, and castle directories.
Perceive and come upon apartments for rent and home rentals San Francisco California.
We authored, concocted, and originated this extensive website, FRBO.com to be lovely, ravishing, sublime, and fair.
This site, FRBO.com can procure, obtain, incorporate, and incorporate suburban ad directories, studio directories, exclusive classifieds, and oceanfront lists of marked properties beachfront classified advertisements, private lists of marked properties, lakeside ads, and beach classified ads to serve your Davis California route.
|
|
