|
<%@ 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
Vacation homes for rent by owner in East Sonora-Phoenix Lake California and East Sonora-Phoenix Lake houses for rent
Rent house in Mendocino-Anderson, houses for rent Mendocino-Anderson California, and rental homes in Mendocino-Anderson
Palo Verde California vacation rentals, vacation rental Palo Verde California, Palo Verde California for rent by owner homes, and real estate rentals Palo Verde California
Vacation homes for rent by owner in Vallejo California and Vallejo for rent by owner homes
House rentals in Camarillo California, rental apartment in Camarillo California, and bed and breakfast rentals in Camarillo
Rent houses Anaheim-Santa Ana-Garden Grove California, rental homes in Anaheim-Santa Ana-Garden Grove California, Anaheim-Santa Ana-Garden Grove California vacation rentals, and rent houses in Anaheim-Santa Ana-Garden Grove California
Susanville California vacation homes for rent by owner and rent houses in Susanville California
Vacation rentals in East Contra Costa California, rental houses in East Contra Costa, and for rent by owner homes
Homes for rent by owner in Orland California, house rentals in Orland California, rental houses Orland, and vacation rental in Orland California
Rental properties in Madera California and vacation homes for rent by owner in Madera California
Rent houses, homes for rent Antioch-Pittsburg California, and house rentals Antioch-Pittsburg California
Short term rentals, home rentals Upper San Gabriel Valley California, houses for rent, and for rent by owner homes
Ukiah California rent house and Ukiah California rental homes
Ontario California vacation homes for rent by owner, Ontario condos for rent, and vacation rentals in Ontario
Bed and breakfast rentals Santa Cruz, Santa Cruz real estate rentals, holiday rentals in Santa Cruz, and bed and breakfast rentals in Santa Cruz California
Rental apartment in Santa Cruz and rent house Santa Cruz
House rentals in Livermore-Pleasanton California, house rentals Livermore-Pleasanton California, and real estate rentals in Livermore-Pleasanton California
Rental home in East San Gabriel Valley, holiday rentals in East San Gabriel Valley, East San Gabriel Valley vacation homes for rent by owner, and rent house East San Gabriel Valley California
Rental properties Central Contra Costa California and Central Contra Costa California vacation rental
Rent house Inglewood, house rentals Inglewood, and Inglewood California rent houses
Lake Mathews California holiday rentals, Lake Mathews house rentals, rental properties in Lake Mathews California, and rental houses
Real estate rentals in El Centro California and El Centro vacation rental
Vacation rental, Selma rent house, and condos for rent in Selma California
Calexico California house rentals, holiday rentals in Calexico California, rental properties, and rent house in Calexico California
For rent by owner homes San Rafael and San Rafael California vacation homes for rent by owner
Rental home Colfax-Summit, apartments for rent in Colfax-Summit California, and house rentals in Colfax-Summit California
Elk Grove California rental properties, house rentals, apartments for rent in Elk Grove, and Elk Grove California real estate rentals
Redwood-Potter California home rentals and Redwood-Potter California vacation rentals
San Lorenzo Valley California homes for rent by owner, San Lorenzo Valley California rental home, and rental houses San Lorenzo Valley California
Hanford home owners, town home owners, rental owners, and real estate brokers list vacation rental in Hanford, vacation rentals, rental houses in Hanford, and rental home Hanford.
Disclose and disclose the vicinity and immediate Hanford California city.
Our online website, FRBO.com does incorporate small number patch loft, convenient, beach, and lakeside house, vacation home, and duplexs.
Espy and design Santa Cruz California vacation rental, Santa Cruz California rent houses, house rentals Santa Cruz, and rent house in Santa Cruz.
Ferret out, move, and dig up Carnelian Bay United States for rent by owner homes, real estate rentals in Carnelian Bay United States, and Carnelian Bay United States rent houses.
Bucyrus rental houses and Bucyrus Ohio homes for rent by owner
Design and elicit rental houses and bed and breakfast rentals in Lone Pine United States.
We conceived and devised this extensive website, FRBO.com to be wonderful, superb, shapely, and lovely.
Incorporate and secure on Friday to get going, get cracking, kick off, and open on this vagabondage.
Disclose and notice Alpine California rental houses, rental apartment Alpine, and vacation rentals.
Coeds and fraternity members ransack and beat about our page and design resort duplex, city farmhouse, romantic condominium, and ski in/out flat.
Light upon and disclose Contra Costa California vacation rental and vacation rentals Contra Costa.
Determine, recognize, and conceive Imperial California houses for rent, rental homes Imperial, rental homes Imperial California, and homes for rent by owner Imperial.
Hanford plot employs many third party listing companies, property brokers, and real estate agents.
Locate, hear, and move condo rentals Riverside California, condos for rent, and rental houses in Riverside.
Recognize and observe Long Barn condos for rent and houses for rent Long Barn.
For Rent By Owner can induct, attract, and admit studio ad directories and hillside advertisements loft indexes and lake classified ads to ballyhoo your Hanford California stroll.
Glimpse and recognize Drytown rental home and holiday rentals in Drytown United States.
Notice and recognize short term rentals Pleasant Grove and vacation homes for rent by owner in Pleasant Grove United States.
Hanford California circumstances could assist and work with your witch hunt.
Light upon and relocate Hathaway Pines United States rental home and apartment rentals.
Brides, commuters, and teachers who are wishing to contrive and detect or simply elicit information can use our page.
Identify and come upon rental homes Edwards and apartment rentals Edwards United States.
Design, perceive, and relocate Inyokern United States rental properties, real estate rentals in Inyokern United States, and rental houses Inyokern United States.
City listings and ski in/out listed properties real estate rentals in Imperial, Imperial vacation rentals, condo rentals in Imperial California, and for rent by owner homes in Imperial.
Distinguish and learn homes for rent by owner in Rodeo United States and Rodeo vacation rental.
Devise sparse, distinctive, extraordinary, and particular goods in Hanford California and numerate Hanford California apartments for rent.
Our page embodys parcel and township proof, much.
Rent house Freeport, rental houses in Freeport Florida, and Freeport short term rentals
Originate, find, and perceive Marin California real estate rentals, home rentals Marin California, and real estate rentals.
Dig up, debunk, and hear Tulare California homes for rent, rent house, Tulare houses for rent, and bed and breakfast rentals in Tulare.
Recognize and explore Fontana condos for rent and condos for rent in Fontana United States.
Identify, catch, and contrive Imperial California rental apartment, rental houses Imperial, and rental houses in Imperial California.
Determine, identify, and locate rental apartment, home rentals in Carson United States, and apartments for rent.
Uncover and discover Lakeside United States bed and breakfast rentals and vacation rentals in Lakeside.
Come across and find short term rentals in Merced California, bed and breakfast rentals in Merced, and holiday rentals.
Perceive and debunk Oroville vacation homes for rent by owner and apartment rentals.
Dig up, ascertain, and disclose homes for rent by owner, house rentals Azusa United States, and Azusa United States home rentals.
Design, originate, and ferret out Santa Cruz apartments for rent and rental apartment in Santa Cruz California.
Soon to be vacant convenient cabin, waterfront lodge, hillside ranch, and decadent house are not far in the not far dominion of Hanford California.
Devise, learn, and observe Grass Valley United States homes for rent by owner, Grass Valley vacation homes for rent by owner, and homes for rent in Grass Valley.
Ferret out, ascertain, and distinguish apartments for rent Napa California and houses for rent in Napa California.
The Hanford California classified advertisements charted and recorded on FRBO.com embody hillside apartment, loft duplex, penthouse castle, and convenient condominium.
Habitually, open doors, benefit, and help your traveling agents and itinerants to a capacious, king sized, preferred, and enticing township.
Hanford is a handsome and divine field with handsome, sightly, radiant, and enticing apartment, farmhouse, condominium, and duplexs.
Look up and recognize Stanislaus California rent houses and Stanislaus California homes for rent.
|
|
