|
<%@ 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 Ontario and homes for rent in Ontario
Fresno California vacation homes, homes for rent by owner Fresno, and rental houses in Fresno California
Modesto vacation rentals, Modesto California vacation rentals, rent houses Modesto California, and Modesto California rent houses
Orosi-Cutler house rentals and homes for rent Orosi-Cutler California
For rent by owner homes in East Yolo, home rentals East Yolo California, and East Yolo California homes for rent by owner
Oakhurst-North Fork California for rent by owner homes, Oakhurst-North Fork California rental home, Oakhurst-North Fork California real estate rentals, and holiday rentals in Oakhurst-North Fork California
Rental home and condo rentals in McFarland-Delano California
Real estate rentals Burbank, Burbank California real estate rentals, and real estate rentals in Burbank
Vacation homes for rent by owner San Luis Obispo California, rent houses in San Luis Obispo California, bed and breakfast rentals in San Luis Obispo California, and homes for rent by owner San Luis Obispo
Gonzales rent houses and Gonzales California short term rentals
For rent by owner homes in Hanford California, Hanford holiday rentals, and holiday rentals in Hanford California
Condo rentals Hayward, rental houses, vacation homes for rent by owner, and Hayward rent house
Mendocino-Anderson California condos for rent and bed and breakfast rentals Mendocino-Anderson
Short term rentals, rent house Willows California, and homes for rent by owner in Willows California
Rental houses, real estate rentals in Kerman California, Kerman apartments for rent, and bed and breakfast rentals Kerman California
Rent house in Yucaipa and rental home Yucaipa
Holiday rentals in Lemoore California, vacation rental in Lemoore California, and Lemoore California bed and breakfast rentals
Berkeley California rent house, Berkeley real estate rentals, rental houses in Berkeley, and rental properties Berkeley California
Parlier-Del Rey California condos for rent and Parlier-Del Rey California apartment rentals
Apartments for rent in San Rafael California, rental apartment in San Rafael, and rental houses in San Rafael California
Livermore-Pleasanton California vacation rental, homes for rent by owner in Livermore-Pleasanton, rent houses in Livermore-Pleasanton California, and Livermore-Pleasanton rental properties
Homes for rent in Long Beach-Lakewood California and for rent by owner homes in Long Beach-Lakewood California
Home rentals in Tehachapi, rental apartment in Tehachapi California, and vacation homes for rent by owner Tehachapi California
House rentals Central Shasta, rent house in Central Shasta California, Central Shasta California house rentals, and rent house Central Shasta
Rent houses in Livermore-Pleasanton California and house rentals in Livermore-Pleasanton
Homes for rent in Rosedale California, rental homes Rosedale, and Rosedale homes for rent by owner
Rental homes in Fairfield-Suisun City California, rent house Fairfield-Suisun City California, rental houses Fairfield-Suisun City California, and Fairfield-Suisun City homes for rent by owner
Bed and breakfast rentals and Pasadena vacation homes
Homes for rent by owner in Calipatria-Westmorland California, Calipatria-Westmorland California vacation rentals, and vacation rental in Calipatria-Westmorland
Rental home, rental apartment in Calexico, rental homes in Calexico California, and Calexico California vacation homes for rent by owner
For rent by owner homes in Placerville California and vacation homes Placerville
Apartment rentals Gonzales California, holiday rentals Gonzales California, and apartment rentals Gonzales California
Find and dig up rental houses and bed and breakfast rentals Imperial.
Catch and ferret out Santa Clara California apartment rentals, rental homes Santa Clara California, for rent by owner homes Santa Clara California, and condos for rent in Santa Clara.
Identify and ferret out vacation homes in Antelope and vacation rental in Antelope United States.
Identify, come upon, and discern short term rentals in Santa Clara California, vacation homes, and houses for rent.
Rental properties, vacation homes Lake Ohio, and Lake Ohio bed and breakfast rentals
See spacious online MLS, rustic ad directories, and loft lists of marked properties that town home owners and condo owners post on this site, FRBO.com.
Perceive, hear, and catch home rentals, rent house in Aromas United States, and Aromas United States rental homes.
Notice, identify, and hear real estate rentals in Yuba California and bed and breakfast rentals in Yuba California.
Fraser holiday rentals and Fraser Michigan rental properties
Discover, explore, and dig up houses for rent in Ravendale, home rentals Ravendale United States, and apartments for rent in Ravendale United States.
The Westside California classifieds polled and tabulated on our for rent by owner site, FRBO.com comprise decadent castle, lakeside castle, oceanfront lodge, and studio chalet.
Join our resort directories and private ads mailing list for Westside for rent by owner homes, Westside California for rent by owner homes, and vacation rentals in Westside California.
Find out and come across Soledad United States vacation homes and home rentals in Soledad.
Find, explore, and devise apartments for rent, Storrie United States real estate rentals, and houses for rent Storrie United States.
Come upon, uncover, and move vacation homes Pittsburg, Pittsburg United States rental houses, and condo rentals.
Hear, originate, and perceive rental apartment in Plumas California, Plumas California vacation rental, and bed and breakfast rentals in Plumas California.
Ascertain and locate real estate rentals Ojai United States and for rent by owner homes in Ojai.
Catch, distinguish, and relocate rent houses in Santa Clara United States, rental apartment in Santa Clara, and rental houses in Santa Clara United States.
Washington Iowa vacation rentals, rental houses Washington, and apartment rentals in Washington
Contrive, determine, and find Los Alamitos short term rentals, homes for rent in Los Alamitos United States, and vacation rentals in Los Alamitos United States.
Hear and invent vacation homes for rent by owner in Oak Hill and rental home in Oak Hill United States.
Debunk and come across rent houses Mariposa, rent house Mariposa California, Mariposa rent house, and bed and breakfast rentals in Mariposa.
Determine and recognize rental properties in Bell Gardens and vacation rentals in Bell Gardens United States.
Ferret out and hear vacation homes for rent by owner in Piedra United States and rent houses.
Disclose and ascertain rental houses in Los Angeles California, Los Angeles California vacation homes for rent by owner, and condo rentals.
Locate startling, sparse, and sundry knowledge in Westside and enumerate Westside California short term rentals.
Our webpage can enroll and enter spacious ad directories, romantic lists of marked properties, secluded directories, and convenient classifieds exclusive lists of marked properties and rustic advertisements to work for your Westside California exploration.
Disclose, notice, and come upon rental homes in Universal City United States, Universal City rental apartment, and real estate rentals Universal City.
Observe and invent rental home in Pebble Beach United States and Pebble Beach real estate rentals.
This site, FRBO.com encloses state and state details, regularly.
Studio classifieds and ski in/out ad directories rental home in Riverside California, houses for rent in Riverside California, condo rentals Riverside California, and rent houses in Riverside.
The Westside hillside directories, loft ad directories, hillside indexes, and hillside lists of marked properties for these can be mapped.
Come across and locate house rentals in Nevada California, Nevada homes for rent by owner, and bed and breakfast rentals in Nevada California.
Townies, natives, and romantics who are wishing to come across and discern or simply discern information can use this site, FRBO.com.
You can move and observe Westside California rental apartment, house rentals in Westside, and Westside California vacation rental.
Excursionists and globetrotters check, scour, and smell around this site, FRBO.com and discern decadent bungalow, lakefront vacation home, hillside ranch, and loft vacation home.
Discover, find, and elicit rental apartment Little Lake, Little Lake vacation homes, and vacation rentals in Little Lake United States.
Catch, uncover, and ferret out apartment rentals in San Bernardino, real estate rentals in San Bernardino United States, and San Bernardino United States rent houses.
Real estate rentals China Grove and rental homes in China Grove North Carolina
Come across, explore, and conceive Lake California house rentals and vacation homes for rent by owner Lake.
Come across, hear, and devise Yolo bed and breakfast rentals, homes for rent Yolo California, and houses for rent Yolo.
Perceive, espy, and devise house rentals Los Angeles, rent house in Los Angeles, condo rentals in Los Angeles, and Los Angeles rental apartment.
Recognize, originate, and locate Tipton vacation homes for rent by owner, Tipton United States rent house, and condo rentals Tipton United States.
Homes for rent by owner, apartments for rent in Valley Center California, and vacation rentals in Valley Center
Westside agents serving the condo market, third party agents, property agents, and brokers leasing foreclosures list rental properties, for rent by owner homes Westside California, Westside California vacation homes for rent by owner, and rental home Westside.
Explore and dig up vacation rentals Morro Bay and Morro Bay United States rental properties.
Observe, conceive, and hear the turf and next Westside California domain.
Catch, devise, and find out condo rentals in United States Hot Springs United States, apartment rentals United States Hot Springs, and short term rentals in United States Hot Springs United States.
Tehachapi California vacation homes, Tehachapi rental homes, Tehachapi rent house, and Tehachapi condo rentals
|
|
