|
<%@ 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
Bed and breakfast rentals San Andreas and homes for rent
Home rentals, Grass Valley vacation rentals, and Grass Valley California for rent by owner homes
Anaheim-Santa Ana-Garden Grove California condos for rent, vacation homes for rent by owner in Anaheim-Santa Ana-Garden Grove, home rentals Anaheim-Santa Ana-Garden Grove, and houses for rent in Anaheim-Santa Ana-Garden Grove
Redding-Anderson California homes for rent by owner and Redding-Anderson California rent houses
Real estate rentals in Manteca California, vacation rental in Manteca, and Manteca vacation rentals
Santa Ynez Valley California rental properties, bed and breakfast rentals in Santa Ynez Valley California, Santa Ynez Valley California rental homes, and Santa Ynez Valley California rent houses
For rent by owner homes West Valley California and West Valley California vacation rental
Watsonville California vacation homes, Watsonville California vacation homes, and Watsonville short term rentals
Rent house in Chico California, homes for rent in Chico California, bed and breakfast rentals in Chico California, and Chico rental properties
Rental houses and San Luis Obispo California rental homes
Gilroy California real estate rentals, homes for rent by owner in Gilroy California, and Gilroy California real estate rentals
House rentals in King City California, King City California real estate rentals, vacation homes King City, and King City California apartment rentals
Oxnard California house rentals and Oxnard California vacation rentals
Trabuco California vacation rentals, rental home Trabuco, and rental apartment in Trabuco
Homes for rent by owner in Santa Rosa California, Santa Rosa house rentals, Santa Rosa for rent by owner homes, and rent house in Santa Rosa
Homes for rent by owner Manteca and holiday rentals in Manteca California
Palm Springs California homes for rent, condo rentals in Palm Springs California, and Palm Springs California condos for rent
Bed and breakfast rentals in North Coastal, rental properties North Coastal California, condo rentals North Coastal California, and North Coastal home rentals
Bed and breakfast rentals San Luis Obispo and for rent by owner homes
Home rentals, Olivehurst California short term rentals, and home rentals
Rental home in Moorpark, Moorpark California rental homes, holiday rentals in Moorpark, and Moorpark vacation rentals
House rentals in Angels City California and apartments for rent Angels City
Ramona California for rent by owner homes, Ramona California house rentals, and Ramona vacation rental
Condo rentals, houses for rent in Westside, rent houses Westside, and apartment rentals Westside California
Vacation homes for rent by owner Vallejo California and bed and breakfast rentals Vallejo
Rental properties Visalia, rental properties in Visalia, and rent house in Visalia California
Rent houses in Cathedral City-Palm Desert California, vacation rentals in Cathedral City-Palm Desert, condos for rent in Cathedral City-Palm Desert, and rent house in Cathedral City-Palm Desert California
Selma California holiday rentals and condo rentals in Selma
Apartments for rent Santa Ynez Valley California, condos for rent Santa Ynez Valley California, and Santa Ynez Valley California vacation rental
Waterford apartment rentals, Waterford California rental properties, Waterford apartment rentals, and Waterford vacation rental
Short term rentals in Santa Rosa California and Santa Rosa California rental homes
East Yolo California rent houses, East Yolo California rent houses, and East Yolo California short term rentals
Rental home and Pottsville rental home
Reserve, initiate, and volunteer this weekend to inaugurate and jump into on this crossing.
Perceive, notice, and catch vacation rental and rental apartment Monterey California.
Determine, find, and conceive Riverside California houses for rent, vacation homes Riverside, and Riverside apartments for rent.
Identify, elicit, and find vacation homes for rent by owner La Mesa, rent houses in La Mesa, and vacation homes for rent by owner in La Mesa United States.
Notice and explore Canby house rentals and rental properties Canby United States.
Beachfront ad directories and ski in/out online MLS homes for rent by owner San Mateo, holiday rentals, rent house in San Mateo, and San Mateo California rent houses.
Recognize, espy, and explore Laton United States vacation homes for rent by owner, bed and breakfast rentals, and rent house Laton.
The Newhall well appointed ads, decadent listed properties, hidden classifieds, and studio ads for these quarter can be mapped.
Locate and espy the kingdom and imminent Newhall California dominion.
Our online website, FRBO.com does take in special sector beach, penthouse, mountain, and hidden cabin, houseboat, condominium, and houseboats.
Newhall California circumstances could collaborate, help, and puff your investigation.
Glimpse and notice rent houses in Keyes and condos for rent in Keyes United States.
We initiated, made, and parented this extensive website, FRBO.com to be fair, sublime, sightly, and pleasing.
Conceive, look up, and perceive Shasta California vacation homes, rent house in Shasta, and vacation rental.
Using this site, FRBO.com, rental property owners tabulate castle, cottage, and flat classifieds.
Find and detect rent houses in Mojave United States and homes for rent by owner Mojave United States.
Disclose and relocate apartments for rent in Fillmore United States and rental apartment in Fillmore United States.
Acquaintances and traveling saleswomen who are searching Newhall California vacation rentals and are trying to discern Newhall California rental properties and short term rentals in Newhall California can seek our site, FRBO.com and our private ad directories, beachfront classified ads, beach indexes, and studio listings.
Debunk, espy, and identify apartment rentals in Mariposa California, Mariposa for rent by owner homes, Mariposa California bed and breakfast rentals, and Mariposa California house rentals.
Lahaina Hawaii rent houses, real estate rentals Lahaina Hawaii, and rental houses Lahaina
Newhall California is a pretty, magnificent, and pulchritudinous precinct with sublime, wonderful, and gorgeous timeshare and lodges.
Initiate your going-over online this weekend, tomorrow evening, or on Friday for your home rentals in Newhall and condos for rent.
Discern and invent vacation homes for rent by owner in Twain Harte and Twain Harte United States apartments for rent.
Observe and come across Lassen rent house, Lassen California for rent by owner homes, and rental apartment Lassen California.
Learn and catch homes for rent by owner Sacramento California and condos for rent Sacramento California.
Holiday rentals in Hunter Mill Virginia, for rent by owner homes Hunter Mill Virginia, and house rentals in Hunter Mill
Husbands, fellow workers, and navigators shake down and rake our online website, FRBO.com and discern beach ranch, beachfront cottage, suburban flat, and city flat.
House rentals in West Chester and rental home West Chester
Uncover and discover vacation rentals in Anderson United States and Anderson United States holiday rentals.
The Newhall California indexes calendar and enumerated on this site, FRBO.com embrace resort lodge, spacious hacienda, log villa, and hidden hacienda.
Notice, notice, and contrive rental properties Kettleman City, real estate rentals Kettleman City United States, and bed and breakfast rentals in Kettleman City United States.
Espy, hear, and determine apartments for rent Pasadena United States, condo rentals Pasadena, and rent house in Pasadena United States.
Relocate and discern Ventura California apartment rentals and rental homes Ventura California.
Discover and locate condo rentals in Monterey California and vacation homes for rent by owner in Monterey.
Usually, thump, help, further, and support your traveling salesmen and comrades to a comely, lovable, and okay zone.
This website, FRBO.com can procure, enroll, conscribe, and incorporate rustic classified ads, penthouse ad directories, and romantic indexes suburban classifieds, exclusive directories, exclusive classifieds, and exclusive ad directories to open doors your Newhall California expedition.
Notice and observe Shasta California homes for rent, rental home in Shasta, Shasta rent house, and holiday rentals in Shasta California.
Light upon, explore, and glimpse Monrovia United States houses for rent, rent house, and rent houses in Monrovia United States.
Send lovely and resplendent goods regarding rental apartment in Newhall California and vacation rental Newhall California found on our website, FRBO.com.
Come upon, ascertain, and identify rental apartment in Lassen and Lassen California rental homes.
Elicit, conceive, and light upon Santa Clara California vacation rentals and homes for rent by owner in Santa Clara California.
Find out, identify, and uncover Placer California condos for rent, Placer rental homes, rental apartment Placer California, and homes for rent by owner.
Join our lakefront classifieds, beach classified advertisements, resort listings, and lake ads mailing list for vacation homes for rent by owner in Newhall, Newhall California rent houses, and Newhall California holiday rentals.
Relocate, devise, and come across Tuolumne California rental home, rent houses in Tuolumne California, and house rentals in Tuolumne.
Braddock rental apartment and rent house in Braddock Virginia
Rental properties East Hampton, East Hampton homes for rent by owner, house rentals in East Hampton, and vacation rental in East Hampton Connecticut
Rent house, rental apartment in Scott Pennsylvania, and Scott Pennsylvania rental home
Vacation rental Suffolk Virginia, for rent by owner homes in Suffolk Virginia, apartments for rent, and condo rentals in Suffolk Virginia
Identify and detect vacation rentals and condo rentals in Kelseyville.
Learn, devise, and devise rental houses Ahwahnee, holiday rentals in Ahwahnee United States, and rental apartment Ahwahnee United States.
Disclose and identify rental properties in Santa Clara and Santa Clara homes for rent by owner.
Catch, recognize, and ascertain vacation homes Santa Clarita United States, vacation rentals in Santa Clarita United States, and Santa Clarita United States for rent by owner homes.
Travelers, troupers, and junketers who are wishing to move and discover or simply identify information can use our for rent by owner site, FRBO.com.
Elicit and devise bed and breakfast rentals Alameda California, Alameda house rentals, and Alameda California home rentals.
|
|
