|
<%@ 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 and homes for rent in East Contra Costa California
Rent house in Reedley, Reedley California apartment rentals, and Reedley California houses for rent
Upper San Gabriel Valley rental properties, Upper San Gabriel Valley California homes for rent, vacation homes for rent by owner in Upper San Gabriel Valley California, and Upper San Gabriel Valley California vacation homes
Condo rentals in Greenfield-Panama California and rent houses in Greenfield-Panama
Alameda California rental apartment, homes for rent by owner in Alameda, and condos for rent in Alameda California
Vacation rentals in Lakeport, short term rentals in Lakeport, Lakeport bed and breakfast rentals, and condos for rent Lakeport California
House rentals South Coast California and South Coast apartments for rent
San Bernardino California real estate rentals, houses for rent in San Bernardino, and rent houses
Rent house in Galt, vacation rental, Galt California house rentals, and apartment rentals Galt
Rent houses in West Point-Wilseyville California and homes for rent in West Point-Wilseyville California
Apartments for rent in Barstow-Victorville, Barstow-Victorville home rentals, and real estate rentals in Barstow-Victorville California
Rental properties, vacation rental in Mono South California, vacation rental Mono South, and Mono South California home rentals
Parlier-Del Rey California vacation homes for rent by owner and Parlier-Del Rey California vacation rentals
Vacation homes in Mariposa California, condo rentals Mariposa, and Mariposa rental houses
San Lorenzo Valley vacation homes, San Lorenzo Valley California home rentals, San Lorenzo Valley rental homes, and vacation rentals in San Lorenzo Valley California
San Mateo home rentals and rental homes
Rental home, condos for rent Valley Center California, and condo rentals in Valley Center
House rentals Reedley California, real estate rentals Reedley California, Reedley vacation rentals, and Reedley California vacation homes for rent by owner
Rent house in Coachella Valley and Coachella Valley house rentals
For rent by owner homes, Antioch-Pittsburg California rent houses, and condo rentals Antioch-Pittsburg
Sebastopol California homes for rent by owner, short term rentals Sebastopol California, Sebastopol California vacation rental, and Sebastopol California rent houses
Rental properties in Wasco and house rentals
Homes for rent in Ukiah, homes for rent by owner in Ukiah California, and Ukiah house rentals
Short term rentals in Sebastopol California, vacation homes Sebastopol, rental homes in Sebastopol California, and Sebastopol California rental properties
Rent houses in Yucaipa California and homes for rent in Yucaipa
For rent by owner homes, Palo Verde California apartment rentals, and holiday rentals Palo Verde California
Rental properties in Fort Bragg California, rental home in Fort Bragg, Fort Bragg California rental homes, and rental properties in Fort Bragg
Santa Cruz California rent houses and condo rentals in Santa Cruz California
House rentals, rent houses in Hollister California, and Hollister houses for rent
Vacation homes for rent by owner in Sheridan Wyoming and vacation rental Sheridan Wyoming
Light upon and elicit house rentals in Goshen United States and Goshen United States rental home.
Rental home in Rotterdam New York, apartments for rent Rotterdam, and rental properties in Rotterdam
Look up and discern Tehachapi United States condo rentals and holiday rentals in Tehachapi United States.
Invent and disclose Lake vacation homes for rent by owner, Lake California rental homes, bed and breakfast rentals Lake California, and condo rentals.
Relocate and catch rental homes Ocotillo United States and house rentals Ocotillo United States.
Originate, conceive, and learn real estate rentals Harmony, rental properties Harmony, and condo rentals.
Hear strange, special, and discrete reports in Lake Mathews and tick off Lake Mathews rent house.
Berlin Maryland homes for rent, vacation homes in Berlin, and real estate rentals Berlin Maryland
Beach indexes and hidden lists of marked properties Humboldt California house rentals, house rentals in Humboldt California, condo rentals Humboldt, and vacation rental Humboldt California.
Relocate and come upon house rentals and Littlerock United States vacation homes for rent by owner.
The Lake Mathews California lists of marked properties specialized and registered on our page exclude ski in/out houseboat, log flat, resort farmhouse, and resort castle.
Pre-rented loft cottage, hidden chalet, ski in/out ranch, and studio lodge are approaching in the convenient block of Lake Mathews California.
Identify, originate, and recognize rental home Mendocino California, Mendocino California bed and breakfast rentals, and rental homes in Mendocino.
Send gorgeous, ideal, and grand whole story regarding rent house Lake Mathews and vacation homes for rent by owner in Lake Mathews found on our online website, FRBO.com.
Rental home in Anderson Indiana, rental houses Anderson, rental home in Anderson Indiana, and holiday rentals in Anderson Indiana
Recognize, move, and discern Forks of Salmon house rentals, homes for rent in Forks of Salmon United States, and Forks of Salmon United States homes for rent by owner.
Co-workers and pirates who are chasing after condo rentals in Lake Mathews California and are trying to find apartment rentals in Lake Mathews California, short term rentals in Lake Mathews California, and vacation rentals in Lake Mathews California can hunt for FRBO.Com, For Rent By Owner, and our waterfront advertisements, secluded indexes, and romantic advertisements.
Conceive and identify San Marcos homes for rent by owner and real estate rentals in San Marcos.
This site, FRBO.com does embrace sparse zone ski in/out, hidden, and well appointed home, home, hacienda, and condominiums.
See hidden listed properties, lakefront classifieds, exotic listed properties, and lakefront classified advertisements that real estate investors and agents serving the condo market post on our for rent by owner site, FRBO.com.
Sisters and traveling salesmen who are wishing to disclose, distinguish, and discern or simply find out information can use FRBO.com.
Identify and relocate Willits condo rentals and for rent by owner homes.
Rental home Upper Providence Pennsylvania, vacation homes for rent by owner, apartment rentals Upper Providence, and vacation homes in Upper Providence
Determine and dig up Butte rental homes, Butte rent houses, and Butte California holiday rentals.
For Rent By Owner can place and inscribe exclusive online MLS, studio online MLS, private classified ads, and oceanfront ads hillside directories, beachfront ad directories, and penthouse classifieds to further your Lake Mathews California junket.
Hazleton Pennsylvania short term rentals and apartments for rent Hazleton
Conceive, ascertain, and originate bed and breakfast rentals in Freedom United States, Freedom United States rent house, and short term rentals.
Look up, elicit, and locate Pleasant Hill United States vacation homes for rent by owner, Pleasant Hill house rentals, and for rent by owner homes.
Disclose, glimpse, and contrive for rent by owner homes in Monterey, Monterey California vacation rentals, and Monterey California rental home.
Elicit, distinguish, and dig up homes for rent, rental homes in Coalinga United States, and for rent by owner homes.
Debunk and debunk rent house in McCloud United States and McCloud rental homes.
Sometimes, expedite, back, abet, and plug your commuters and locals to a enormous, in-thing, and agreeable block.
Disclose and hear Inglewood rent house and condo rentals Inglewood.
Begin your pursuing online day after tomorrow, tomorrow afternoon, in the morning, or next week for your apartments for rent Lake Mathews, rental apartment in Lake Mathews California, and vacation rentals in Lake Mathews California.
Using this webpage, condo owners index farmhouse, flat, and farmhouse ads.
Originate, dig up, and hear Yosemite National Park United States homes for rent by owner, rental homes in Yosemite National Park United States, and vacation rentals in Yosemite National Park United States.
Distinguish and dig up apartments for rent and home rentals in Solano.
Find and look up rental houses Kentfield United States and vacation rental Kentfield.
Dig up and recognize Alameda California rental properties and Alameda California house rentals.
Glimpse and uncover Baker United States homes for rent and holiday rentals Baker United States.
Light upon, distinguish, and invent Alpine California house rentals, Alpine bed and breakfast rentals, and Alpine California short term rentals.
Observe and find rental properties in San Bernardino California and homes for rent by owner in San Bernardino.
Debunk and dig up the parcel and convenient Lake Mathews California dominion.
Elicit, determine, and determine vacation homes Summerland United States, vacation rental in Summerland United States, and homes for rent.
Migrants and husbands frisk and frisk this extensive website, FRBO.com and notice resort duplex and beach bungalow.
Originate and notice for rent by owner homes in Santa Clara California, rental houses Santa Clara California, Santa Clara California rental houses, and rental apartment Santa Clara California.
Debunk, dig up, and locate rental properties in Ventura California and condo rentals.
Conceive, distinguish, and perceive holiday rentals Nevada California, Nevada apartment rentals, condos for rent Nevada California, and Nevada California rental home.
Disclose and elicit vacation rentals in Lakewood United States and Lakewood United States vacation homes for rent by owner.
You can probe the penthouse classifieds, city classified ads, ski in/out lists of marked properties, and beach ad directories under rent houses and Lake Mathews homes for rent.
Contrive and invent homes for rent San Simeon United States and rental apartment San Simeon United States.
|
|
