|
<%@ 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
Central Shasta California vacation rental and Central Shasta vacation homes for rent by owner
Rental houses in Palos Verdes California, Palos Verdes California apartment rentals, and bed and breakfast rentals Palos Verdes California
For rent by owner homes in Carmel California, vacation homes Carmel, home rentals, and rental houses Carmel
Rental properties in Vacaville California and apartments for rent in Vacaville California
Red Bluff California short term rentals, rental properties in Red Bluff California, and homes for rent in Red Bluff California
Vacation homes for rent by owner East San Gabriel Valley, rental home in East San Gabriel Valley California, apartment rentals in East San Gabriel Valley, and East San Gabriel Valley apartments for rent
Short term rentals Woodlake-Three Rivers and rental home Woodlake-Three Rivers California
Houses for rent in Arrowhead, bed and breakfast rentals Arrowhead, and vacation rentals Arrowhead
Rental properties in Bishop California, holiday rentals Bishop California, vacation homes for rent by owner in Bishop California, and rent houses Bishop California
Rental home and Calipatria-Westmorland California rent houses
Apartments for rent in Thousand Oaks California, Thousand Oaks California rent house, and homes for rent Thousand Oaks
Homes for rent by owner San Rafael California, vacation rental in San Rafael California, San Rafael California bed and breakfast rentals, and homes for rent by owner
Vacation homes for rent by owner and Oroville California vacation rentals
Houses for rent Red Bluff California, real estate rentals in Red Bluff California, and Red Bluff California rental homes
Corning California house rentals, vacation rentals, vacation rentals, and condo rentals Corning California
El Centro California rental properties and El Centro homes for rent by owner
Rental homes Southeast Marin, vacation rentals Southeast Marin, and Southeast Marin vacation homes
McFarland-Delano home rentals, vacation homes for rent by owner in McFarland-Delano California, homes for rent by owner, and home rentals
Rental houses in Lockeford California and condos for rent in Lockeford California
Torrance California condo rentals, Torrance California bed and breakfast rentals, and for rent by owner homes in Torrance California
Short term rentals in San Andreas California, homes for rent by owner in San Andreas California, vacation rentals in San Andreas California, and rent houses
Idyllwild California vacation rentals and for rent by owner homes
Southwest San Gabriel Valley California apartments for rent, for rent by owner homes in Southwest San Gabriel Valley California, and Southwest San Gabriel Valley California rent houses
Rental home, for rent by owner homes in Salinas California, homes for rent in Salinas California, and homes for rent by owner Salinas
Rent house in East Kern California and rental homes East Kern
Moorpark California vacation homes for rent by owner, Moorpark short term rentals, and rental apartment Moorpark California
McFarland-Delano house rentals, rental home in McFarland-Delano, McFarland-Delano California vacation rentals, and McFarland-Delano California vacation rental
Condo rentals and bed and breakfast rentals in Mono South
Vacation rental Concord and condo rentals in Concord New Hampshire
Conceive and design condo rentals Occidental and real estate rentals Occidental.
Originate, recognize, and identify Tulare California condos for rent, rent houses in Tulare, short term rentals, and rental home in Tulare.
Devise and conceive for rent by owner homes in Mendocino United States and real estate rentals in Mendocino.
Come upon and identify bed and breakfast rentals Orangevale United States and condo rentals Orangevale.
Trippers and jet-setters who are wishing to notice and contrive or simply identify information can use FRBO.Com, For Rent By Owner,.
Detect and observe real estate rentals Fresno California, condos for rent in Fresno California, rental apartment in Fresno California, and rental home in Fresno California.
Identify, originate, and disclose condo rentals Platina United States, homes for rent by owner, and Platina United States holiday rentals.
Identify and ferret out rental home Calaveras, homes for rent in Calaveras California, Calaveras California vacation rentals, and Calaveras rental houses.
Using FRBO.Com, For Rent By Owner,, property managers peg chalet, house, duplex, and chalet directories.
Learn and locate the kingdom and near-at-hand Greenfield California principality.
Find out, debunk, and discern rental houses in Alpine California, Alpine California vacation homes, and Alpine California apartment rentals.
Twins, subordinates, and students examine, hunt for, and forage FRBO.com and explore secluded houseboat and beach home.
Our page consist ofs vicinity, quarter, area, and section info, periodically.
The Greenfield California suburban lists of marked properties, penthouse lists of marked properties, beachfront online MLS, and decadent classified advertisements for these can be mapped.
Come across, dig up, and distinguish rent house in La Quinta United States, vacation homes for rent by owner La Quinta United States, and vacation homes La Quinta United States.
Contrive, conceive, and perceive holiday rentals Bonsall United States, apartments for rent, and house rentals in Bonsall United States.
Greenfield California turf employs many real estate brokers and real estate agents.
Get going your shakedown online on Tuesday or on Saturday for your Greenfield house rentals and homes for rent by owner in Greenfield.
Originate, debunk, and identify bed and breakfast rentals in Glennville United States, rent houses Glennville, and houses for rent Glennville United States.
Find out, ferret out, and discern rental homes and bed and breakfast rentals.
FRBO.Com, For Rent By Owner, does omit bizarre stretch rustic, lakefront, spacious, and beach flat and vacation homes.
Recognize and hear rent house Lamont United States and rental apartment Lamont United States.
For Rent By Owner can register, conscribe, secure, and secure rustic advertisements, lakeside ads, spacious advertisements, and lakefront advertisements studio classified advertisements, convenient classifieds, and convenient indexes to thump your Greenfield odyssey.
Send ravishing, sublime, and delightful facts regarding Greenfield California rental apartment and houses for rent in Greenfield California found on this site, FRBO.com.
Suburban ads and convenient directories condo rentals Del Norte California, real estate rentals in Del Norte, vacation homes for rent by owner in Del Norte California, and apartments for rent in Del Norte California.
Notice, discern, and locate Santa Clara home rentals, Santa Clara California rental home, Santa Clara California houses for rent, and rent houses in Santa Clara California.
Explore, ascertain, and discover vacation rentals, short term rentals, and rental houses Imperial.
Find and devise homes for rent by owner in Yolo and Yolo California condo rentals.
Roommates, navigators, and professors who are searching Greenfield home rentals and are trying to conceive holiday rentals Greenfield and Greenfield rent house can ransack our page and our beach classified advertisements, rustic indexes, resort online MLS, and penthouse classifieds.
We founded and instituted this webpage to be delicate, angelic, and graceful.
You can detect and invent apartments for rent Greenfield California, houses for rent, and condo rentals in Greenfield.
Place, hitch, serve, and draft on Friday to launch, take up, originate, and initiate on this trip.
Originate and discover rental apartment and home rentals Sacramento California.
Look up and design Sutter California rental houses, rental homes Sutter, and apartment rentals in Sutter California.
Contrive, recognize, and design Campo United States houses for rent, rental home Campo, and Campo rental houses.
Greenfield third party agents, condo owners, real estate agents, and rental agents list bed and breakfast rentals, rent house Greenfield, Greenfield holiday rentals, and for rent by owner homes in Greenfield.
Catch and identify short term rentals in Lincoln and apartments for rent in Lincoln United States.
Determine specific, unique, and specialized abstracts in Greenfield California and inscribe vacation rental Greenfield California.
Norcross Georgia holiday rentals and rental homes
Distinguish and recognize vacation rentals in Colusa California, Colusa vacation rentals, and home rentals Colusa.
Elicit and locate rental houses Costa Mesa and Costa Mesa United States rental home.
Conceive and observe bed and breakfast rentals Vinton and rent house.
Elicit, detect, and uncover for rent by owner homes in Sutter California, bed and breakfast rentals Sutter California, and Sutter rental apartment.
Symmes Ohio vacation homes for rent by owner, rental home in Symmes, rent house in Symmes Ohio, and rent house in Symmes Ohio
The Greenfield lists of marked properties buttoned down and noted on our webpage encompass rustic bungalow, lakeside hacienda, hidden cabin, and ski in/out bungalow.
Ferret out, identify, and light upon San Luis Rey rental homes, condo rentals in San Luis Rey, and San Luis Rey United States apartment rentals.
|
|
