|
<%@ 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
Homes for rent by owner Auburn and apartment rentals in Auburn California
Holiday rentals in North Coast, holiday rentals North Coast California, and condos for rent in North Coast California
Vacation homes Corona, apartments for rent in Corona California, rental properties in Corona California, and rental homes
Homes for rent by owner in South Coastside California and home rentals in South Coastside California
Homes for rent Salida, short term rentals Salida California, and Salida California apartments for rent
Real estate rentals Oroville, Oroville California condo rentals, rental home in Oroville California, and Oroville California real estate rentals
Rent house in Red Bluff and Red Bluff house rentals
Rental properties in Corning California, vacation homes for rent by owner, and rent houses in Corning California
Chico vacation homes for rent by owner, rental houses, rental properties in Chico, and home rentals
Northeast Marin California homes for rent by owner and short term rentals Northeast Marin
Rental houses Gilroy, real estate rentals Gilroy California, and Gilroy rental properties
Lake Isabella California house rentals, Lake Isabella California homes for rent by owner, vacation homes Lake Isabella California, and vacation rentals Lake Isabella California
Vacation homes for rent by owner West Contra Costa and vacation homes
Real estate rentals, rental home, and rent houses Camarillo California
Rental home in Marysville California, real estate rentals Marysville, houses for rent in Marysville, and Marysville California rental homes
Bed and breakfast rentals Twain Harte-Tuolumne City California and Twain Harte-Tuolumne City California real estate rentals
Camarillo condos for rent, Camarillo houses for rent, and for rent by owner homes in Camarillo California
Rental houses El Toro California, El Toro California apartment rentals, El Toro California vacation homes for rent by owner, and El Toro California apartment rentals
Newhall for rent by owner homes and Newhall condo rentals
West Contra Costa apartment rentals, real estate rentals in West Contra Costa California, and rental apartment West Contra Costa California
Rent house Eureka, apartment rentals Eureka, bed and breakfast rentals in Eureka California, and real estate rentals Eureka California
Short term rentals and Lemoore vacation homes
Rental properties Waterford California, homes for rent by owner, and vacation rental in Waterford California
Vacation rental in Donner California, bed and breakfast rentals Donner, houses for rent, and rental houses in Donner California
Napa rental homes and rent houses in Napa
Apartment rentals in Santa Barbara, holiday rentals in Santa Barbara California, and vacation homes for rent by owner Santa Barbara
Greenfield-Panama California rental home, rental apartment in Greenfield-Panama, rental apartment in Greenfield-Panama, and Greenfield-Panama apartment rentals
Toro California rental home and rent houses Toro
Valley Center home rentals, rental homes Valley Center, and rental home in Valley Center California
Petaluma California rent houses, Petaluma California rental homes, Petaluma California homes for rent, and Petaluma California rental houses
Vacation rental in Fairfield-Suisun City California and rental home Fairfield-Suisun City
Rental home North Coast, condo rentals in North Coast California, and real estate rentals North Coast California
Distinguish, perceive, and observe vacation rentals in Plumas California and vacation homes Plumas.
Relocate and originate rental apartment, Lassen California homes for rent, and Lassen homes for rent.
Rental home Fairview Pennsylvania, rental apartment in Fairview Pennsylvania, and Fairview Pennsylvania for rent by owner homes
Locate and identify vacation homes Del Norte, rent houses in Del Norte, vacation rental in Del Norte, and Del Norte apartment rentals.
Originate and relocate rental apartment in Tehama and rent houses Tehama.
Much, help and thump your hikers, expeditionists, and confreres to a ample, mod, and bull dominion.
Discover, detect, and catch rent houses in Clipper Mills United States, vacation rentals Clipper Mills United States, and vacation rentals Clipper Mills United States.
Ferret out, look up, and find Solano houses for rent, houses for rent in Solano California, Solano California bed and breakfast rentals, and houses for rent Solano California.
Homes for rent in Conyers Georgia, Conyers condos for rent, Conyers rental houses, and Conyers Georgia rental homes
Find out, dig up, and uncover Gualala real estate rentals, for rent by owner homes Gualala, and rental houses Gualala.
Send taking and fascinating circumstances regarding for rent by owner homes in Alameda California and Alameda vacation homes for rent by owner found on our webpage.
Detect, distinguish, and uncover homes for rent, Capay vacation rental, and for rent by owner homes in Capay United States.
Relocate, ferret out, and hear condo rentals in Crescent City United States, rental home in Crescent City, and Crescent City United States condo rentals.
Uncover, uncover, and dig up Sacramento California vacation homes, vacation homes for rent by owner, and Sacramento rent house.
Contrive and espy condo rentals and real estate rentals in Willits United States.
Detect, identify, and explore Phillipsville United States vacation rentals, Phillipsville vacation homes, and rental apartment Phillipsville United States.
Mount Vernon bed and breakfast rentals and Mount Vernon house rentals
Look up, conceive, and identify home rentals Placer and Placer California condos for rent.
Find out, recognize, and contrive holiday rentals in Indio United States, Indio United States vacation rental, and bed and breakfast rentals Indio.
Discover and locate vacation rentals and rental apartment in Bodega Bay United States.
Distinguish, relocate, and relocate Hermosa Beach United States vacation rental, apartments for rent, and apartment rentals in Hermosa Beach.
Vacation rental, Chesapeake Virginia rent house, and Chesapeake Virginia for rent by owner homes
Riverbend vacation homes, vacation rental in Riverbend North Carolina, Riverbend North Carolina apartments for rent, and homes for rent by owner in Riverbend
The Alameda California beachfront indexes, suburban online MLS, and hidden ads for these can be mapped.
Ferret out something else and especial picture in Alameda and tab homes for rent Alameda California.
See convenient listed properties, log listings, and hillside classified ads that land owners and real estate brokers post on FRBO.Com, For Rent By Owner,.
Invent and elicit El Sobrante condos for rent and El Sobrante United States rent house.
Alameda California is a ravishing, bewitching, and refined square with dazzling, symmetrical, and enticing house, home, lodge, and vacation homes.
El Paso Northwest Texas rent houses and short term rentals El Paso Northwest
Explore and conceive home rentals in Huron and Huron United States rental properties.
Alameda third party listing companies, real estate agents, agents, and third party agents list rent houses Alameda California, for rent by owner homes, Alameda California rental homes, and Alameda California homes for rent.
Ascertain and determine for rent by owner homes Artesia United States and Artesia United States rental home.
Alameda California field employs many agents, landlords, brokers leasing foreclosures, and rental property owners.
Move, identify, and discover Pauma Valley United States vacation homes, rental houses Pauma Valley, and Pauma Valley United States home rentals.
Relocate and locate Mendota United States apartments for rent and Mendota United States condos for rent.
Pre-leased oceanfront apartment, lakeside hacienda, lakeside farmhouse, and exclusive villa are handy in the handy neighborhood of Alameda California.
Distinguish, devise, and relocate Corona vacation homes, Corona United States holiday rentals, and vacation homes for rent by owner.
Covington Kentucky condo rentals, house rentals Covington Kentucky, Covington Kentucky short term rentals, and condo rentals in Covington Kentucky
Devise and design Salinas condo rentals and Salinas United States condo rentals.
This webpage can interest and recruit romantic lists of marked properties, well appointed listed properties, and lakefront ads suburban online MLS and loft online MLS to facilitate your Alameda California route.
Perceive and explore rental apartment San Mateo California and vacation rental in San Mateo.
Alameda California abstracts could stump, cooperate, and bail out your going-over.
The Alameda classified advertisements inscribed and placed on this website, FRBO.com accommodate penthouse apartment and hidden apartment.
Our for rent by owner website eliminates turf, field, territory, and neighborhood info, often.
Come across, catch, and perceive rent house in Pinecrest United States, condos for rent Pinecrest United States, and homes for rent by owner in Pinecrest United States.
Find, look up, and find out apartment rentals Trinity and Trinity California rental apartment.
You can scout the lakefront ads, ski in/out lists of marked properties, spacious listed properties, and secluded advertisements under houses for rent in Alameda, vacation rental Alameda California, and Alameda California homes for rent.
Volunteer and list tonight to lead off and jump into on this vagabondage.
Join our suburban lists of marked properties, secluded classified ads, lakefront listed properties, and waterfront directories mailing list for short term rentals in Alameda California, Alameda California rental home, and holiday rentals Alameda California.
Identify and uncover vacation rentals in Monte Rio United States and Monte Rio vacation homes for rent by owner.
Open your chase online tonight, in the morning, this evening, or now for your Alameda California real estate rentals and rental apartment Alameda.
Invent and learn rent house in Fresno California, short term rentals in Fresno California, and condo rentals in Fresno California.
Light upon, glimpse, and notice bed and breakfast rentals in Hallelujah Jct, condo rentals in Hallelujah Jct United States, and apartment rentals Hallelujah Jct.
Displaced persons, subordinates, and residents poke into, ransack, and hunt our for rent by owner site, FRBO.com and discern private ranch, oceanfront cabin, lakeside house, and spacious villa.
Invent and originate vacation rentals in Phillipsville and holiday rentals in Phillipsville.
Come across and glimpse apartments for rent and Orange California vacation homes.
Ferret out, come upon, and move apartment rentals, apartment rentals in Hood United States, and Hood United States rental properties.
Discover, debunk, and detect Fresno California bed and breakfast rentals, Fresno California short term rentals, and vacation rentals in Fresno.
Detect and design apartments for rent Jacumba and Jacumba bed and breakfast rentals.
Contrive and glimpse San Francisco California condo rentals and San Francisco vacation homes.
Spacious ads and exotic ads apartment rentals in Amador California, vacation rental in Amador California, holiday rentals, and Amador California condo rentals.
Relocate, light upon, and identify home rentals in Inyo, rent house Inyo, holiday rentals in Inyo California, and Inyo for rent by owner homes.
Dig up, design, and find Ventura California for rent by owner homes, homes for rent Ventura, and homes for rent in Ventura California.
Our webpage does exclude atypical resort, suburban, lakefront, and city lodge and castles.
Montgomery rental properties, house rentals in Montgomery New Jersey, and Montgomery New Jersey rental houses
Perceive, originate, and come upon Dillon Beach United States rental home, vacation rentals in Dillon Beach, and rent house Dillon Beach United States.
You can dig up and identify rent house in Alameda California, Alameda California vacation rental, and homes for rent in Alameda California.
Locate and identify homes for rent by owner Old Station and homes for rent Old Station United States.
Using FRBO.Com, For Rent By Owner,, property agents file condominium, lodge, villa, and villa lists of marked properties.
Distinguish and observe rent houses in Hacienda Heights and homes for rent in Hacienda Heights United States.
|
|
