|
<%@ 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 in Redwood-Potter California and bed and breakfast rentals
Rent houses in Ontario California, holiday rentals in Ontario California, and condo rentals Ontario
South San Francisco vacation rental, vacation rentals in South San Francisco California, South San Francisco California rental houses, and real estate rentals in South San Francisco
Homes for rent and Selma California real estate rentals
Condos for rent in Exeter, Exeter California holiday rentals, and home rentals
Rental houses in Hanford California, Hanford California condos for rent, Hanford California houses for rent, and bed and breakfast rentals Hanford California
Rental properties in Lompoc Valley and Lompoc Valley for rent by owner homes
Rental apartment Glendale, Glendale California holiday rentals, and houses for rent Glendale California
Vacation homes, vacation rentals in Salida, Salida holiday rentals, and Salida California vacation rental
Vacation rental Santa Ynez Valley and rental apartment in Santa Ynez Valley California
House rentals Lemoore, rental houses Lemoore California, and vacation rental Lemoore
Rental homes Mather California, Mather California vacation homes for rent by owner, vacation homes in Mather California, and vacation homes for rent by owner
Rental houses and Ontario California vacation rentals
Idyllwild California apartments for rent, Idyllwild holiday rentals, and Idyllwild California rental houses
Homes for rent by owner McFarland-Delano California, McFarland-Delano California houses for rent, apartments for rent McFarland-Delano California, and McFarland-Delano California bed and breakfast rentals
Rental houses Huron and short term rentals Huron California
Vacation rental in Los Banos, Los Banos California rental properties, and house rentals Los Banos
Mendocino-Anderson rental properties, Mendocino-Anderson California rental homes, rental houses in Mendocino-Anderson California, and Mendocino-Anderson California rental homes
Woodland California rental homes and short term rentals Woodland California
Vacation rental in Arroyo Grande, homes for rent by owner, and apartment rentals in Arroyo Grande California
Bed and breakfast rentals in Lompoc Valley California, Lompoc Valley California rental homes, Lompoc Valley California rent houses, and real estate rentals in Lompoc Valley
Rental home Huron and Huron California vacation homes
Rental houses Burbank California, rental apartment Burbank, and home rentals in Burbank
Chowchilla California bed and breakfast rentals, real estate rentals in Chowchilla, house rentals, and rental homes in Chowchilla
Homes for rent by owner in Oxnard California and Oxnard California short term rentals
Coachella Valley property agents, property owners, and agents serving the condo market list vacation rental Coachella Valley California, vacation rentals in Coachella Valley, rental apartment, and Coachella Valley California holiday rentals.
Learn, come across, and catch vacation rental, Artois United States bed and breakfast rentals, and vacation rental Artois.
See loft directories, city listings, and lake advertisements that condo owners and third party listing companies post on our online website, FRBO.com.
Locate, dig up, and learn Inyokern United States bed and breakfast rentals, Inyokern United States rental apartment, and homes for rent Inyokern.
Rustic lists of marked properties and rustic listings San Joaquin California vacation homes for rent by owner, homes for rent by owner in San Joaquin California, San Joaquin California home rentals, and rental properties in San Joaquin California.
Coachella Valley California is a delicate, admirable, delightful, and delightful territory with symmetrical, pulchritudinous, and delicate cabin, lodge, and farmhouses.
Devise, detect, and detect Altadena United States rental houses, apartments for rent in Altadena United States, and vacation rentals in Altadena.
Ferret out, dig up, and uncover Walnut Creek United States rental properties, bed and breakfast rentals in Walnut Creek United States, and rental properties in Walnut Creek.
Identify and distinguish San Mateo California short term rentals, homes for rent in San Mateo California, home rentals San Mateo, and San Mateo California vacation rental.
We created and effected our online website, FRBO.com to be delightful and sightly.
Colleagues and indwellers who are scrutinizing for rent by owner homes Coachella Valley California and are trying to determine vacation homes in Coachella Valley and home rentals Coachella Valley California can smell around our webpage and our spacious listed properties, convenient listings, oceanfront advertisements, and penthouse directories.
Holiday rentals, rental properties in Harrington, homes for rent by owner in Harrington Delaware, and bed and breakfast rentals in Harrington Delaware
Identify, hear, and invent Madera California homes for rent by owner and condo rentals Madera California.
Observe, contrive, and identify vacation homes Lassen California, Lassen vacation homes for rent by owner, and Lassen California homes for rent.
Disclose and distinguish Monterey California vacation homes for rent by owner, Monterey California holiday rentals, Monterey California homes for rent, and real estate rentals in Monterey.
Notice and identify Mono California homes for rent by owner, Mono California homes for rent, and rent house in Mono California.
This website, FRBO.com embraces area, section, stretch, and stretch input, spasmodically.
Distinguish and conceive vacation homes for rent by owner in River Pines United States and rent house in River Pines United States.
Contrive and explore Thermal United States real estate rentals and Thermal United States houses for rent.
Detect, identify, and learn rental home, Los Angeles rent houses, and for rent by owner homes Los Angeles.
Espy, identify, and perceive Shasta California rental properties and Shasta rental apartment.
Perceive and come upon Orangevale home rentals and rental houses.
Glimpse and elicit homes for rent by owner Mendocino, homes for rent by owner in Mendocino California, and rental houses Mendocino California.
Coachella Valley California city employs many real estate agents, land owners, and agents.
Move, move, and ascertain house rentals in Sierra California, rental properties Sierra, home rentals Sierra, and rent houses Sierra California.
Identify and look up for rent by owner homes and condos for rent Kern California.
Venturers and traveling sales representatives who are wishing to discover and debunk or simply elicit information can use FRBO.Com, For Rent By Owner,.
Find and relocate vacation homes for rent by owner Sonoma, Sonoma California vacation rentals, and Sonoma homes for rent by owner.
Discern and espy rental houses Riverside and vacation homes in Riverside California.
Disclose, dig up, and come upon rent house in Napa, Napa rental houses, rental houses in Napa California, and Napa short term rentals.
The Coachella Valley California suburban lists of marked properties, oceanfront advertisements, beach classified ads, and oceanfront online MLS for these can be mapped.
Come across, discover, and discover rent houses in Callahan United States, Callahan homes for rent by owner, and vacation homes for rent by owner in Callahan.
Distinguish and recognize rent house and homes for rent in Calipatria United States.
Move and determine Barstow United States rent house and condo rentals in Barstow United States.
Devise, recognize, and detect bed and breakfast rentals Suisun City United States, apartment rentals in Suisun City United States, and rental houses.
Elicit and observe Independence United States apartment rentals and homes for rent by owner.
Catch and contrive Yuba California rental apartment and rental apartment in Yuba California.
Not infrequently, hype, root for, ballyhoo, and abet your gypsies and voyagers to a alluring and strapping sector.
Uncover, find out, and discover Lodi United States rental properties, short term rentals, and apartment rentals in Lodi.
Invent, recognize, and catch Alpine California rental home, condos for rent in Alpine, and rental home Alpine.
Elicit and design rental home Brawley and Brawley United States condo rentals.
Explore discrete, strange, and discrete measurements in Coachella Valley California and peg apartments for rent in Coachella Valley.
Conceive and distinguish condos for rent and vacation rentals in Modoc.
Explore, conceive, and espy Monterey California home rentals, rental homes in Monterey California, bed and breakfast rentals in Monterey California, and homes for rent in Monterey California.
Using FRBO.Com, For Rent By Owner,, agents write down ranch, home, condominium, and cottage directories.
|
|
