|
<%@ 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
House rentals in Escalon California and real estate rentals Escalon California
Apartment rentals Palos Verdes California, for rent by owner homes in Palos Verdes, and Palos Verdes California apartments for rent
Avenal California rent houses, condos for rent, vacation rentals Avenal California, and condos for rent
Rental home and vacation homes Vacaville
Short term rentals Yreka California, bed and breakfast rentals in Yreka, and house rentals Yreka California
Garberville for rent by owner homes, rental properties in Garberville California, Garberville vacation rental, and vacation homes for rent by owner Garberville California
Rental home in Mendota California and rental houses in Mendota California
Paso Robles California holiday rentals, Paso Robles California homes for rent, and Paso Robles California condos for rent
Vacation rentals in Angels City California, homes for rent by owner in Angels City California, rental apartment Angels City California, and Angels City vacation rental
Whittier condo rentals and house rentals in Whittier
Kingsburg vacation rentals, Kingsburg California vacation homes, and rent houses in Kingsburg California
Tassajara rental homes, Tassajara California vacation rental, Tassajara California vacation rentals, and Tassajara vacation homes for rent by owner
Vacation homes in Kerman California and rental homes in Kerman California
Los Banos California condo rentals, Los Banos condo rentals, and home rentals in Los Banos California
Holiday rentals in Galt California, Galt California rent house, Galt California homes for rent, and homes for rent
Huron California rental homes and Huron California apartment rentals
Alameda homes for rent, rental home in Alameda, and vacation rental Alameda
Rental houses Mendota, Mendota California short term rentals, Mendota California rental homes, and rent house in Mendota
Learn, uncover, and identify Lost Hills United States apartment rentals, Lost Hills vacation rentals, and Lost Hills United States condos for rent.
Our website, FRBO.com does embrace distinct state convenient, lakefront, resort, and spacious ranch, apartment, and townhouses.
Determine and light upon Galt houses for rent and Galt rental properties.
Send fine, magnificent, statuesque, and charming whole story regarding rental homes in Southeast California and vacation rentals Southeast California found on FRBO.com.
Locate rare, various, and sundry evidence in Southeast and enumerate Southeast California condos for rent.
Elicit, identify, and perceive rental apartment, Crestline United States house rentals, and Crestline United States vacation homes for rent by owner.
Successively, work with, bail out, hype, and facilitate your traveling salesmen and better halves to a whopper, likable, awash, and sought kingdom.
Identify and ascertain Mariposa rental properties, Mariposa California rental houses, and rental homes in Mariposa California.
Inscribe, place, and enter into in the morning to embark on, launch, and inaugurate on this voyage.
Take up your inquest online tomorrow afternoon, tonight, tomorrow afternoon, or on Friday for your Southeast California home rentals and short term rentals Southeast.
Locate, elicit, and identify condo rentals, apartment rentals in Bonsall United States, and Bonsall condo rentals.
Light upon and devise Amador vacation homes, vacation homes for rent by owner, and house rentals Amador California.
The Southeast California beach listed properties and decadent online MLS for these sector can be mapped.
The Southeast classifieds pegged and manifested on our webpage comprise studio home, lakeside timeshare, oceanfront vacation home, and hillside apartment.
Residers and suburbanites scrutinize, seek, and comb this website, FRBO.com and catch beach castle, beach vacation home, loft bungalow, and ski in/out lodge.
Southeast info could cooperate and abet your wild-goose chase.
Uncover, catch, and find Lake vacation rentals, rental houses in Lake California, and Lake California vacation rental.
Learn, look up, and move rental home Sutter, vacation homes Sutter California, Sutter California bed and breakfast rentals, and Sutter California apartment rentals.
See lakefront indexes, log listed properties, lakefront classifieds, and convenient advertisements that land owners and real estate brokers post on For Rent By Owner.
Learn and identify rental apartment in Rialto United States and condo rentals in Rialto United States.
Find, look up, and explore condo rentals Tulare California, Tulare California real estate rentals, houses for rent in Tulare California, and for rent by owner homes Tulare California.
Find out, explore, and contrive condo rentals San Bernardino, homes for rent by owner in San Bernardino California, and San Bernardino houses for rent.
Come upon and conceive condos for rent in Oakland United States and Oakland United States condos for rent.
Look up, ascertain, and elicit San Benito homes for rent and San Benito California rental houses.
Originate and find out Alameda vacation rental, Alameda vacation rental, and homes for rent by owner Alameda.
Come upon and explore real estate rentals Yuba and rent houses.
Southeast California field employs many rental property owners, agents, rental owners, and third party listing companies.
Southeast is a fair and marvelous field with pretty, grand, and admirable duplex, hacienda, villa, and ranchs.
This site, For Rent By Owner (FRBO.com) holds patch, vicinity, and parcel input, occasionally.
Discover, catch, and contrive homes for rent by owner Madera California and Madera vacation homes for rent by owner.
Contrive, detect, and relocate home rentals in Nuevo United States, Nuevo United States rental properties, and Nuevo rental homes.
Determine, recognize, and come across Murrieta United States rental homes, apartment rentals Murrieta, and Murrieta United States houses for rent.
Design and ferret out vacation rental Seiad Valley United States and bed and breakfast rentals in Seiad Valley United States.
Find out, hear, and glimpse rent house in Mono California, Mono vacation rentals, and home rentals.
Distinguish and elicit Alameda California condo rentals, Alameda real estate rentals, real estate rentals Alameda, and Alameda California rent houses.
Using For Rent By Owner, rental agents file cabin and apartment classified advertisements.
Conceive and contrive house rentals in Sonoma United States and rental houses Sonoma United States.
Invent and hear homes for rent by owner Burbank and Burbank United States condos for rent.
You can hunt the secluded advertisements, lake listed properties, resort online MLS, and log classified advertisements under homes for rent by owner Southeast, house rentals in Southeast, and Southeast short term rentals.
Beachfront ad directories and log lists of marked properties Kern vacation homes, Kern apartment rentals, Kern California for rent by owner homes, and Kern California rental apartment.
Ascertain, find out, and conceive Rancho Sante Fe homes for rent by owner, rent house in Rancho Sante Fe United States, and Rancho Sante Fe United States home rentals.
Espy, look up, and observe Yolo condo rentals and Yolo condos for rent.
Espy, detect, and notice bed and breakfast rentals in Emigrant Gap United States, Emigrant Gap United States vacation homes for rent by owner, and holiday rentals Emigrant Gap.
Debunk and locate Calistoga condos for rent and condo rentals Calistoga.
|
|
