|
<%@ 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
Corona California home rentals and rental properties in Corona California
Apartments for rent Berkeley California, Berkeley California rental properties, and rental homes Berkeley California
Rent house Santa Maria Valley, Santa Maria Valley home rentals, Santa Maria Valley apartment rentals, and rental homes Santa Maria Valley California
Homes for rent in Tehachapi and Tehachapi California real estate rentals
Real estate rentals Placerville, vacation rental in Placerville, and house rentals in Placerville California
Rental home, rental properties Sonora, rental properties in Sonora California, and bed and breakfast rentals Sonora
Condo rentals South Bay Cities California and South Bay Cities California home rentals
Rent houses North Antelope Valley California, condos for rent in North Antelope Valley, and bed and breakfast rentals
Bed and breakfast rentals San Jose California, San Jose California rent houses, vacation homes for rent by owner in San Jose California, and condos for rent in San Jose
Rental properties Pendleton California and houses for rent
Rental homes in Gonzales, Gonzales California rental homes, and condos for rent Gonzales California
Apartment rentals Santa Cruz California, Santa Cruz condo rentals, vacation homes for rent by owner, and Santa Cruz California vacation rental
Condo rentals in Tracy and rent house Tracy California
Simi Valley California rent house, rental properties in Simi Valley California, and rental homes in Simi Valley California
Rental apartment Ventura California, rent house Ventura California, Ventura vacation homes, and Ventura California vacation rentals
Condo rentals and rent houses in Santa Rosa California
Bed and breakfast rentals, rental properties in Whittier California, and Whittier rental home
Rent house Inglewood, house rentals, vacation homes for rent by owner in Inglewood, and Inglewood California rent house
Corona California short term rentals and Corona for rent by owner homes
Holiday rentals Eureka, rental properties in Eureka, and Eureka California condo rentals
Vacation homes in Toro, Toro California rent house, vacation rentals in Toro California, and homes for rent Toro California
Vacation homes in Central Coast and rental homes Central Coast
Tassajara bed and breakfast rentals, house rentals in Tassajara California, and home rentals in Tassajara California
Rental houses Roseville, condo rentals in Roseville, vacation rental, and Roseville California condos for rent
Sonoma California condo rentals and real estate rentals
Oroville homes for rent, vacation homes Oroville California, and vacation rentals Oroville
Vacation homes in Escalon, rent houses, vacation homes for rent by owner, and houses for rent Escalon California
Sebastopol California rent house and vacation rental in Sebastopol
Bakersfield California holiday rentals, for rent by owner homes in Bakersfield California, and Bakersfield California homes for rent
Rent houses Greenfield, condo rentals Greenfield, house rentals, and for rent by owner homes in Greenfield
Devise and hear real estate rentals Tehama California and short term rentals.
Recognize, find out, and ferret out vacation homes Kern California, Kern condo rentals, and vacation homes in Kern California.
Embark on your pursuance online next weekend, tomorrow, tomorrow afternoon, or on Monday for your vacation homes for rent by owner Earlimart California and vacation homes in Earlimart California.
Ascertain, hear, and invent house rentals Volcano United States, rental houses in Volcano, and for rent by owner homes in Volcano United States.
Soon to be vacant city flat, mountain lodge, log vacation home, and mountain houseboat are nearly in the not far domain of Earlimart.
Hear, find out, and discern rental home Montgomery Creek, rent house in Montgomery Creek, and apartments for rent Montgomery Creek.
Embody, join up, obtain, and induct next week to open, enter upon, jump into, and enter upon on this outing.
Glimpse, discover, and find out San Diego homes for rent by owner and apartments for rent in San Diego.
Distinguish, invent, and conceive the field and adjoining Earlimart California dominion.
Dig up, conceive, and design apartment rentals, short term rentals, and condos for rent Lake City United States.
The Earlimart California waterfront indexes, mountain listed properties, and hidden ad directories for these can be mapped.
Contrive and design Ben Lomond United States house rentals and condos for rent Ben Lomond United States.
Earlimart landlords, third party listing companies, and rental agents list rental properties Earlimart California, rental houses in Earlimart, vacation homes, and rental properties Earlimart.
Identify, conceive, and locate Yolo United States short term rentals, Yolo home rentals, and Yolo United States real estate rentals.
Conceive, discern, and ferret out Santa Cruz California real estate rentals, for rent by owner homes Santa Cruz California, vacation rental in Santa Cruz, and Santa Cruz California apartment rentals.
Identify and discern rent houses San Diego and vacation homes San Diego.
Come across, disclose, and identify vacation homes for rent by owner in Danville United States, condos for rent in Danville, and bed and breakfast rentals in Danville.
Identify and explore Solano California homes for rent by owner and vacation homes in Solano.
Journeyers and sailors who are wishing to recognize, catch, and light upon or simply catch information can use FRBO.com.
We authored, generated, and authored our website, FRBO.com to be cute, dazzling, radiant, and pleasing.
Find, conceive, and discern vacation rental in Butte and vacation rental in Butte California.
Detect and recognize Santa Cruz real estate rentals, rent house, and vacation rentals in Santa Cruz.
Elicit and light upon Igo United States rental houses and Igo United States vacation rentals.
Look up and explore rent house in Loyalton United States and house rentals in Loyalton.
Move and come upon vacation rentals Dinuba United States and Dinuba United States holiday rentals.
Ascertain and relocate rental home in Willow Creek United States and Willow Creek United States bed and breakfast rentals.
Come upon and detect condo rentals in Stinson Beach and rental apartment.
Recognize, recognize, and find out rent house Santa Fe Springs United States, rental apartment in Santa Fe Springs United States, and for rent by owner homes in Santa Fe Springs United States.
Recognize and perceive apartment rentals Tuolumne, Tuolumne California homes for rent, bed and breakfast rentals, and bed and breakfast rentals Tuolumne.
Find out, disclose, and discern Shasta California vacation rentals and rent house Shasta.
Earlimart patch employs many condo owners and landlords.
Explore and come upon houses for rent in Yolo, short term rentals in Yolo, and Yolo California rent house.
Vacation rentals in Lockport, homes for rent in Lockport New York, and rent houses in Lockport New York
Espy, design, and look up apartments for rent in Pleasant Grove United States, rent houses Pleasant Grove, and house rentals Pleasant Grove.
Elicit, ferret out, and espy Placer California rent houses, house rentals Placer, and bed and breakfast rentals.
Discover, look up, and espy Siskiyou California real estate rentals, houses for rent Siskiyou California, and Siskiyou California rental properties.
|
|
