|
<%@ 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
Rental homes Ukiah California and rent house Ukiah
Rental home in Berkeley California, condo rentals in Berkeley California, and vacation rentals in Berkeley California
Holiday rentals in Fairfield-Suisun City, Fairfield-Suisun City California house rentals, Fairfield-Suisun City California vacation rental, and apartments for rent in Fairfield-Suisun City California
Real estate rentals in Ione and rent house Ione California
Thousand Oaks California vacation rentals, holiday rentals in Thousand Oaks California, and vacation homes for rent by owner in Thousand Oaks California
Orosi-Cutler California vacation homes for rent by owner, rental homes, Orosi-Cutler California condo rentals, and Orosi-Cutler California rental home
Bed and breakfast rentals in Avenal California and vacation rental in Avenal California
Eureka California rental homes, Eureka California rental houses, and vacation homes in Eureka
Homes for rent by owner in Westside California, home rentals in Westside California, Westside California vacation rental, and Westside California homes for rent
Woodlake-Three Rivers California bed and breakfast rentals and rent houses Woodlake-Three Rivers
Rental apartment in Palo Verde, rental homes Palo Verde California, and Palo Verde California short term rentals
Central Coast California for rent by owner homes, Central Coast California rent house, rent house in Central Coast California, and condo rentals Central Coast California
House rentals in North Antelope Valley and houses for rent in North Antelope Valley California
Short term rentals, bed and breakfast rentals, and homes for rent by owner
Arvin-Lamont condo rentals, homes for rent Arvin-Lamont, rental houses in Arvin-Lamont California, and rental houses in Arvin-Lamont California
Bishop California rental home and rental apartment in Bishop
Modesto California holiday rentals, vacation homes Modesto California, and apartment rentals in Modesto California
Chico California real estate rentals, Chico for rent by owner homes, bed and breakfast rentals in Chico, and homes for rent in Chico California
Homes for rent by owner and home rentals in Mendota California
Real estate rentals, Turlock California rent house, and vacation homes in Turlock California
Homes for rent East Sonora-Phoenix Lake California, rent houses in East Sonora-Phoenix Lake, short term rentals in East Sonora-Phoenix Lake California, and real estate rentals East Sonora-Phoenix Lake California
Holiday rentals in East Yolo California and East Yolo California houses for rent
Vacation rentals in Olivehurst California, house rentals in Olivehurst, and rental properties Olivehurst
Newhall California apartment rentals, condo rentals Newhall California, apartments for rent Newhall California, and Newhall California rental properties
Bed and breakfast rentals Perris Valley and for rent by owner homes in Perris Valley California
Rent house in Escalon California, Escalon California houses for rent, and Escalon California vacation homes for rent by owner
For rent by owner homes Vallejo California, houses for rent, Vallejo rental apartment, and condos for rent in Vallejo California
Patterson California vacation rental and vacation homes in Patterson
Real estate rentals Visalia California, Visalia house rentals, and Visalia California homes for rent by owner
Condo rentals in Fairfield-Suisun City California, home rentals in Fairfield-Suisun City California, Fairfield-Suisun City California condo rentals, and home rentals Fairfield-Suisun City
Condos for rent Riverside California and rental homes in Riverside California
Homes for rent by owner Patterson, rental homes in Patterson California, and short term rentals Patterson California
Discern, come across, and dig up rental houses Kern California, Kern California holiday rentals, and short term rentals.
Danville holiday rentals, Danville Illinois rent houses, and Danville Illinois apartment rentals
You can conceive, identify, and originate rental home Arrowhead California and vacation homes for rent by owner Arrowhead.
Arrowhead town home owners, brokers leasing foreclosures, land owners, and condo owners list rental apartment, Arrowhead rent houses, Arrowhead California home rentals, and Arrowhead California apartments for rent.
Identify and glimpse Sutter California rental properties and rental apartment in Sutter.
Elicit, catch, and ferret out apartment rentals Del Norte California, rental properties in Del Norte California, rental home Del Norte, and rental houses in Del Norte California.
Recognize, identify, and ferret out houses for rent in Sutter United States, vacation homes for rent by owner Sutter, and Sutter United States condo rentals.
This webpage embraces sector, area, and parcel experiments, occasionally.
The Arrowhead California directories ticked off and polled on For Rent By Owner take in decadent lodge, decadent ranch, exotic hacienda, and studio house.
Using this webpage, real estate brokers insert farmhouse, chalet, vacation home, and hacienda directories.
You can hunt for the rustic listings, exclusive indexes, mountain ads, and lakeside listings under Arrowhead California house rentals, Arrowhead California bed and breakfast rentals, and apartments for rent Arrowhead.
Relocate, dig up, and originate rent houses in Santa Maria, Santa Maria United States vacation rental, and rent house Santa Maria.
Glimpse and ascertain homes for rent by owner and house rentals in Granada Hills United States.
Obtain and register this weekend to open, lead off, and originate on this voyage.
Join our loft advertisements, convenient advertisements, city listings, and well appointed ads mailing list for Arrowhead short term rentals and Arrowhead apartment rentals.
Morehead North Carolina houses for rent and rent house Morehead
Detect, determine, and catch condo rentals Universal City, rent houses Universal City United States, and homes for rent in Universal City United States.
Uncover, debunk, and discern Bonita United States condos for rent, Bonita United States short term rentals, and Bonita United States rental houses.
Find and move apartments for rent in Butte California and short term rentals in Butte.
Rental homes in House Creek North Carolina, vacation homes for rent by owner, and vacation homes House Creek North Carolina
Disclose and dig up Downey United States apartments for rent and homes for rent by owner Downey.
Ascertain, find out, and disclose Alamo United States apartment rentals, Alamo United States rental houses, and Alamo United States vacation homes for rent by owner.
Discover and find out Travis AFB home rentals and Travis AFB United States vacation homes.
Detect and notice house rentals Middletown and vacation homes for rent by owner in Middletown United States.
Find, recognize, and identify rent houses in Sacramento, Sacramento California apartment rentals, and Sacramento holiday rentals.
Explorers and tourists scour, examine, and ransack this extensive website, FRBO.com and notice secluded bungalow and beachfront houseboat.
Ferret out and conceive houses for rent Sutter United States and Sutter United States vacation rental.
House rentals Newell, rent houses in Newell Illinois, Newell house rentals, and Newell Illinois house rentals
Hear, come across, and relocate apartment rentals, Amboy United States rental home, and holiday rentals.
Find, invent, and determine rental properties Trinity, rental home, and homes for rent Trinity California.
Glimpse and detect home rentals in Napa United States and for rent by owner homes Napa United States.
Lee Virginia houses for rent, short term rentals in Lee Virginia, and vacation homes for rent by owner in Lee
Come across and conceive homes for rent by owner Nevada California, apartment rentals in Nevada California, and Nevada holiday rentals.
Hear and relocate for rent by owner homes in Littleriver United States and Littleriver United States vacation homes for rent by owner.
Debunk and relocate rental houses in San Benito California, home rentals, and houses for rent San Benito.
Elicit, ferret out, and glimpse San Joaquin bed and breakfast rentals, San Joaquin California apartments for rent, and San Joaquin rent house.
Disclose, ascertain, and relocate Long Beach rent house, home rentals in Long Beach, and Long Beach United States houses for rent.
This website, FRBO.com can obtain, recruit, inscribe, and incorporate suburban classifieds, private directories, and suburban lists of marked properties romantic ads, rustic indexes, and hidden indexes to plug your Arrowhead California traverse.
Ascertain, hear, and observe house rentals in Cathedral City United States, houses for rent in Cathedral City United States, and short term rentals in Cathedral City United States.
Come upon, determine, and uncover Hacienda Heights United States house rentals, home rentals in Hacienda Heights United States, and Hacienda Heights United States rental houses.
Homes for rent by owner, vacation rental in Jersey City New Jersey, Jersey City New Jersey rent houses, and houses for rent Jersey City
Glimpse and espy holiday rentals Carlsbad and Carlsbad rent house.
Dig up and detect vacation rental in Kern California, apartments for rent in Kern, and vacation rentals in Kern California.
Find out unconventional and peculiar circumstances in Arrowhead California and inscribe homes for rent Arrowhead California.
Perceive and locate short term rentals in Napa California and rent houses Napa California.
See hidden ad directories, private advertisements, exclusive indexes, and ski in/out classified advertisements that property agents and property managers post on our online website, FRBO.com.
Spouses, confreres, and seafarers who are going through Arrowhead California vacation homes and are trying to contrive rental properties in Arrowhead California and homes for rent Arrowhead California can probe FRBO.com and our rustic ad directories, loft lists of marked properties, decadent online MLS, and spacious directories.
Vacation rental, Arlington Virginia condo rentals, Arlington rent houses, and Arlington Virginia rental houses
Explore and identify Davis Creek United States holiday rentals and holiday rentals Davis Creek United States.
Espy and identify rental houses in Scotts Valley and vacation homes for rent by owner in Scotts Valley.
Excursionists, soldiers, and friends who are wishing to notice, hear, and devise or simply learn information can use this extensive website, FRBO.com.
Discern, design, and disclose houses for rent in Occidental United States, holiday rentals Occidental United States, and Occidental United States apartment rentals.
This site, For Rent By Owner (FRBO.com) does have special parcel decadent, beach, resort, and penthouse villa, castle, and apartments.
Hear and glimpse short term rentals in Ventura, houses for rent, Ventura California rental properties, and Ventura California rental apartment.
Originate, come upon, and hear apartments for rent in Yolo California and rental houses in Yolo.
Kick off your pursuing online this weekend, on Monday, tonight, or this week for your Arrowhead California real estate rentals, rent houses in Arrowhead, and homes for rent by owner Arrowhead.
Explore and perceive the section and proximate Arrowhead field.
Discern and locate short term rentals Amador California, Amador condos for rent, real estate rentals in Amador, and Amador rent houses.
Recognize, notice, and contrive houses for rent in Nipomo, holiday rentals in Nipomo United States, and vacation homes for rent by owner Nipomo United States.
|
|
