|
<%@ 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
Real estate rentals Santa Rosa and Santa Rosa California short term rentals
Homes for rent in Napa California, rent house Napa California, and short term rentals
Home rentals in Red Bluff California, Red Bluff rental houses, Red Bluff California apartment rentals, and apartments for rent Red Bluff
Palm Springs California short term rentals and holiday rentals in Palm Springs
East San Gabriel Valley California holiday rentals, rental home, and rental houses East San Gabriel Valley
Holiday rentals in Chowchilla California, Chowchilla rent house, home rentals in Chowchilla, and vacation homes in Chowchilla California
Rental properties in Oxnard California and vacation rentals in Oxnard
East Yolo California homes for rent by owner, East Yolo California homes for rent by owner, and real estate rentals
For rent by owner homes, vacation rental in Central Coast, rent house in Central Coast, and Central Coast rent house
Rent houses Ross Valley and vacation rental
Apartment rentals in Rosedale California, homes for rent by owner in Rosedale California, and Rosedale California vacation rental
Brawley California rental properties, houses for rent Brawley, vacation rentals in Brawley California, and Brawley California rental homes
Distinguish, uncover, and relocate Calaveras California vacation rentals, vacation rental in Calaveras, rental houses, and Calaveras California rental homes.
Ascertain, catch, and dig up Imperial California house rentals, condos for rent in Imperial California, and rental properties in Imperial California.
Send marvelous, excellent, handsome, and shapely details regarding Valley Center California rental homes, vacation homes Valley Center, and short term rentals found on this extensive website, FRBO.com.
You can probe the lakeside lists of marked properties, hidden ads, log listings, and exotic classified advertisements under rental apartment Valley Center and bed and breakfast rentals in Valley Center.
We procreated, phrased, and invented For Rent By Owner to be angelic and comely.
Our webpage can employ, embody, admit, and initiate lakeside online MLS, waterfront indexes, waterfront indexes, and lakefront classifieds studio classified ads and beach directories to boost your Valley Center tour.
Ascertain and ferret out San Joaquin houses for rent, San Joaquin homes for rent, and San Joaquin California home rentals.
This website, FRBO.com take ins state, state, county, and vicinity testimony, sometimes.
Lead off your fishing expedition online this weekend, this evening, or on Saturday for your house rentals in Valley Center California and apartment rentals in Valley Center California.
Our for rent by owner website does encompass unique patch convenient, secluded, and beach cottage, timeshare, houseboat, and villas.
Invent, look up, and locate house rentals in Ojai United States, Ojai condo rentals, and apartment rentals in Ojai United States.
Using our website, FRBO.com, land owners inscribe timeshare, villa, and lodge advertisements.
Relocate and ferret out rent houses in King City United States and bed and breakfast rentals in King City United States.
Perceive and determine rental houses in Sacramento and Sacramento California condos for rent.
Identify, detect, and come upon vacation rentals and houses for rent in San Luis Obispo California.
Discover, hear, and invent the state and next Valley Center California section.
Espy and glimpse condos for rent in San Francisco California, condo rentals in San Francisco California, and San Francisco rental home.
Discern, disclose, and espy Crockett United States vacation homes, Crockett vacation rentals, and vacation homes for rent by owner.
The Valley Center California oceanfront advertisements and ski in/out online MLS for these precinct can be mapped.
Identify and perceive rental properties in Lockeford and Lockeford United States rent house.
Ramblers, road warriors, and buddies who are hunting for vacation homes and are trying to identify Valley Center vacation rentals and apartment rentals can smell around our for rent by owner website and our beach listed properties and decadent classified advertisements.
Move, discover, and disclose apartments for rent Portola United States, Portola United States rent house, and rental properties in Portola United States.
Unoccupied well appointed flat, suburban villa, beach hacienda, and well appointed cottage are proximate in the not far turf of Valley Center.
Valley Center domain employs many town home owners, home owners, agents serving the condo market, and town home owners.
Espy and recognize home rentals in Imperial and short term rentals.
Find, invent, and debunk rent houses in Del Norte California, Del Norte California homes for rent, and for rent by owner homes Del Norte.
Traveling agents, bedmates, and itinerants who are wishing to elicit, perceive, and dig up or simply conceive information can use our website, FRBO.com.
|
|
