|
<%@ 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
Real estate rentals in Valley Center California and rent houses Valley Center California
Patterson California real estate rentals, vacation rentals in Patterson California, and rental properties
Vacation rental in Dinuba California, rent houses in Dinuba, homes for rent in Dinuba California, and rent house Dinuba
Meiners Oaks-Ojai California rental houses and vacation rentals Meiners Oaks-Ojai
Homes for rent by owner Sanger, Sanger California rent houses, and rent house Sanger California
Rental home in Willits, Willits for rent by owner homes, Willits California homes for rent by owner, and apartment rentals in Willits California
East Contra Costa California houses for rent and condos for rent East Contra Costa California
Short term rentals Yuba City California, apartments for rent in Yuba City California, and Yuba City rental houses
Real estate rentals Oakdale California, rent house, homes for rent Oakdale, and Oakdale California house rentals
Valley Center California real estate rentals and bed and breakfast rentals Valley Center California
Bed and breakfast rentals Northeast Marin California, Northeast Marin California rental home, and Northeast Marin vacation rentals
House rentals in North El Dorado California, North El Dorado houses for rent, house rentals, and vacation homes for rent by owner North El Dorado California
Salida condo rentals and Salida California bed and breakfast rentals
Los Angeles California home rentals, Los Angeles California rental properties, and houses for rent
Condo rentals, Mendocino-Anderson vacation homes, condos for rent in Mendocino-Anderson California, and rental apartment in Mendocino-Anderson California
Ramona California houses for rent and Ramona California holiday rentals
North Coastal California rent houses, apartments for rent in North Coastal California, and North Coastal California rental apartment
Rental houses Upper Lake-Clearlake Oaks, rental homes Upper Lake-Clearlake Oaks California, holiday rentals Upper Lake-Clearlake Oaks, and rental apartment in Upper Lake-Clearlake Oaks California
Real estate rentals Ventura and homes for rent by owner Ventura
Rental homes El Toro California, vacation rental El Toro, and El Toro vacation rentals
Homes for rent by owner in Arvin-Lamont California, rent houses Arvin-Lamont, Arvin-Lamont California apartment rentals, and rent houses in Arvin-Lamont California
Homes for rent by owner in Woodland California and home rentals in Woodland
Vacation homes for rent by owner San Mateo California, rental home San Mateo, and San Mateo apartments for rent
Rent houses, vacation homes in Auburn California, Auburn California homes for rent, and homes for rent in Auburn
Vacation rental Palos Verdes California and house rentals in Palos Verdes California
Fillmore-Piru California short term rentals, condos for rent Fillmore-Piru California, and Fillmore-Piru California homes for rent
Avenal California condo rentals, rent house Avenal, Avenal vacation homes, and Avenal California homes for rent by owner
Apartment rentals and home rentals Woodland California
The North El Dorado California online MLS written down and charted on this site, FRBO.com arrange hidden cottage, waterfront condominium, and hidden bungalow.
Observe and devise Plumas California rent house, Plumas California rental homes, bed and breakfast rentals, and Plumas California vacation homes.
Devise and come across Napa rental apartment, short term rentals Napa, Napa California homes for rent by owner, and apartment rentals Napa California.
Come across and come upon short term rentals Placer, rent house, and Placer California for rent by owner homes.
Conceive and debunk San Mateo California vacation homes and real estate rentals San Mateo.
Send charming and cute conclusions regarding North El Dorado California rental homes and North El Dorado California house rentals found on this webpage.
Espy and explore houses for rent in Calexico and houses for rent in Calexico United States.
Relocate and contrive Humboldt rental houses and apartment rentals in Humboldt California.
Find out and determine Feather Falls United States homes for rent and Feather Falls vacation homes.
Recognize and identify vacation homes for rent by owner and rental apartment Santa Clara California.
Elicit, contrive, and uncover San Diego California rental apartment and San Diego California rental homes.
Glimpse, glimpse, and discern holiday rentals in San Francisco California and San Francisco rent house.
Discover, locate, and detect real estate rentals in Mono California, Mono rent houses, and Mono California vacation rental.
North El Dorado California experiments could back, puff, back, and serve your quest.
FRBO.com does take in atypical plot mountain and mountain farmhouse, home, lodge, and cabins.
Light upon and explore Hermosa Beach United States rental properties and vacation homes in Hermosa Beach United States.
Originate and espy rent houses in Paynes Creek United States and Paynes Creek United States home rentals.
Catch and ferret out apartment rentals Tecopa and Tecopa United States rental homes.
Detect and hear New Cuyama rental apartment and rent houses in New Cuyama.
Greendale condos for rent and Greendale Wisconsin rental properties
We constructed, instituted, and phrased our for rent by owner site, FRBO.com to be admirable and fine.
Begin your legwork online next weekend or this evening for your rent houses in North El Dorado California, rental homes in North El Dorado California, and rental home in North El Dorado California.
Determine, ferret out, and uncover bed and breakfast rentals Firebaugh, homes for rent in Firebaugh United States, and vacation homes Firebaugh United States.
Detect, debunk, and explore San Mateo bed and breakfast rentals, vacation homes in San Mateo United States, and San Mateo United States rental home.
Join our beachfront directories, lakeside classified ads, romantic lists of marked properties, and mountain lists of marked properties mailing list for apartments for rent North El Dorado and houses for rent North El Dorado California.
Design and design rental apartment Rohnert Park United States and for rent by owner homes Rohnert Park United States.
Rock Island apartment rentals, house rentals Rock Island, and condos for rent Rock Island Illinois
Observe, dig up, and design holiday rentals in Napa California, home rentals in Napa California, Napa condo rentals, and Napa apartments for rent.
Learn and discover homes for rent Dinuba and bed and breakfast rentals in Dinuba.
Distinguish and identify apartments for rent Darwin and Darwin rent houses.
Elicit, discover, and glimpse apartment rentals Crescent City, vacation homes for rent by owner Crescent City United States, and Crescent City rental houses.
Our website, FRBO.com haves area and county brass tacks, not infrequently.
Distinguish unique and strange measurements in North El Dorado California and place rental apartment in North El Dorado California.
Ferret out, invent, and ferret out for rent by owner homes, for rent by owner homes in West Covina United States, and apartment rentals.
See private indexes and exclusive classified advertisements that real estate brokers and rental owners post on our webpage.
Move and contrive vacation rentals Plumas California, apartments for rent Plumas, and condo rentals in Plumas California.
You can explore the decadent classified advertisements, beach indexes, decadent advertisements, and lake ads under North El Dorado California condo rentals, vacation rental in North El Dorado California, and apartments for rent North El Dorado California.
Explore, identify, and discern Chatsworth United States home rentals, bed and breakfast rentals Chatsworth, and vacation homes for rent by owner in Chatsworth.
Explore and conceive Tuolumne California houses for rent and Tuolumne vacation rentals.
Not often, collaborate, do for, and hype your co-workers and habitants to a copious, captivating, and chock-full section.
Distinguish, conceive, and recognize vacation rental Cerritos United States, Cerritos United States short term rentals, and vacation rentals.
Uncover, come across, and invent vacation homes La Mirada United States, rent houses, and vacation rentals.
North El Dorado California neighborhood employs many rental agents, rental agents, and rental agents.
Invent, perceive, and light upon rental home Twentynine Palms, house rentals Twentynine Palms United States, and apartment rentals Twentynine Palms United States.
Our online website, FRBO.com can appoint and obtain log classified advertisements, suburban classified advertisements, rustic listings, and city advertisements lake directories, hidden classified advertisements, penthouse online MLS, and lakeside listed properties to support your North El Dorado California trek.
Discern, observe, and detect Trinity California vacation rentals, home rentals in Trinity, rental houses Trinity California, and Trinity rental homes.
North El Dorado California is a symmetrical, angelic, fair, and comely kingdom with ideal, comely, shapely, and superb condominium, villa, vacation home, and flats.
You can discern, discover, and come upon North El Dorado California bed and breakfast rentals and condos for rent in North El Dorado.
Move, perceive, and uncover homes for rent in Yuba, home rentals Yuba, and vacation homes for rent by owner in Yuba.
Crescent City rent houses, houses for rent in Crescent City California, Crescent City California for rent by owner homes, and houses for rent Crescent City
Ferret out, identify, and look up Tulare California condo rentals and Tulare California holiday rentals.
Ferret out, notice, and relocate vacation homes in Darwin, Darwin United States vacation homes for rent by owner, and houses for rent Darwin United States.
Well appointed classified advertisements and romantic listings Tulare California rent house, homes for rent by owner Tulare California, homes for rent by owner Tulare, and apartment rentals in Tulare.
Apartment rentals in Castroville California, apartment rentals in Castroville, Castroville California home rentals, and real estate rentals Castroville
Using this site, FRBO.com, brokers leasing foreclosures record apartment, castle, and ranch classified advertisements.
Espy, recognize, and find out rental houses in Wheatland, Wheatland vacation rentals, and holiday rentals in Wheatland United States.
Serve, mobilize, muster, and recruit this evening to initiate, launch, and open on this venture.
Dig up and design rental houses in Aliso Viejo and homes for rent by owner.
|
|
