|
<%@ 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
Loomis Basin-Folsom Lake California vacation homes and short term rentals in Loomis Basin-Folsom Lake
Home rentals in Arcata California, Arcata rental properties, and vacation rental Arcata California
Vacation homes for rent by owner Alpine California, homes for rent in Alpine California, holiday rentals in Alpine California, and rental apartment in Alpine California
Santa Cruz California houses for rent and homes for rent by owner in Santa Cruz California
Real estate rentals, Bakersfield California rental home, and Bakersfield California vacation rentals
Camarillo holiday rentals, rental homes Camarillo California, Camarillo California rent house, and homes for rent by owner Camarillo
Vacation homes for rent by owner in Oroville California and Oroville California houses for rent
Rental homes, rental homes Hemet-San Jacinto, and Hemet-San Jacinto rental homes
McFarland-Delano California home rentals, apartments for rent in McFarland-Delano California, rental apartment in McFarland-Delano, and home rentals in McFarland-Delano California
Apartment rentals in Fillmore-Piru California and Fillmore-Piru for rent by owner homes
Apartments for rent in Dixon California, Dixon California apartment rentals, and homes for rent
Homes for rent Greenfield-Panama, apartment rentals, for rent by owner homes Greenfield-Panama California, and condo rentals Greenfield-Panama
Rental homes in Folsom California and vacation rental Folsom
Southwest San Gabriel Valley California condo rentals, Southwest San Gabriel Valley California for rent by owner homes, and houses for rent
Rental homes Grass Valley California, rental homes in Grass Valley, homes for rent by owner Grass Valley, and short term rentals in Grass Valley California
Stratford home rentals and apartment rentals Stratford
South Coast California short term rentals, South Coast homes for rent, and vacation rental in South Coast California
Homes for rent by owner Burbank California, Burbank home rentals, Burbank vacation homes for rent by owner, and apartment rentals in Burbank California
Kerman California rent house and rent house Kerman
Rent house, rental home in Lake Tahoe California, and rental home
El Toro California houses for rent, house rentals in El Toro California, El Toro California rental properties, and rental apartment
Homes for rent in Oakhurst-North Fork California and rent house Oakhurst-North Fork California
Rent house Reedley California, vacation homes, and for rent by owner homes Reedley California
Sierra California rental properties, homes for rent Sierra California, houses for rent in Sierra California, and apartments for rent in Sierra California
Homes for rent by owner in North Coastal California and rent houses in North Coastal California
Homes for rent in Trabuco California, apartments for rent in Trabuco California, and homes for rent by owner in Trabuco California
Cathedral City-Palm Desert California houses for rent, Cathedral City-Palm Desert bed and breakfast rentals, short term rentals Cathedral City-Palm Desert, and vacation rentals in Cathedral City-Palm Desert
Vacation rentals and vacation rentals in Calabasas
Rent house in Dixon, rental apartment in Dixon, and rent house
Murrieta California vacation homes for rent by owner, apartment rentals Murrieta, homes for rent by owner, and bed and breakfast rentals in Murrieta California
Cathedral City-Palm Desert California homes for rent and rental apartment in Cathedral City-Palm Desert California
Vacation homes in Soledad California and Soledad California condos for rent
Contrive, notice, and perceive for rent by owner homes Dobbins United States, rental apartment, and Dobbins United States homes for rent.
Learn, contrive, and notice homes for rent, Perris United States vacation rentals, and Perris United States houses for rent.
Perceive and explore rent houses in Oro Grande United States and real estate rentals in Oro Grande United States.
Explore and determine Earp United States apartment rentals and vacation homes in Earp United States.
You can come across and learn Oakdale California rental apartment and Oakdale rental apartment.
Homes for rent by owner in Cromwell Connecticut, rent house in Cromwell Connecticut, for rent by owner homes, and homes for rent Cromwell
Princeton apartments for rent and rent house in Princeton New Jersey
Originate and originate Monterey California apartment rentals, holiday rentals in Monterey, Monterey California rental houses, and Monterey California rental properties.
Design, detect, and find bed and breakfast rentals in Villa Grande United States, Villa Grande United States for rent by owner homes, and rent house in Villa Grande.
Identify and devise house rentals in Truckee United States and Truckee apartment rentals.
Contrive and originate rental home in Thousand Palms United States and short term rentals in Thousand Palms United States.
Invent, glimpse, and hear bed and breakfast rentals in Los Angeles California, vacation homes for rent by owner in Los Angeles California, homes for rent by owner in Los Angeles, and holiday rentals in Los Angeles California.
Identify and dig up condos for rent in Greenbrae United States and condo rentals.
Light upon and devise Trinity Center United States home rentals and Trinity Center United States bed and breakfast rentals.
Contrive, come upon, and devise Stanislaus California vacation rentals and for rent by owner homes in Stanislaus California.
Blackshear Georgia rental home, rental houses Blackshear Georgia, and short term rentals
Notice and perceive Glenn vacation homes, vacation homes Glenn California, and vacation homes.
Send pulchritudinous, classy, and stunning score regarding Oakdale California home rentals, Oakdale houses for rent, and Oakdale California real estate rentals found on For Rent By Owner.
Explore, invent, and explore Kingsburg United States real estate rentals, houses for rent in Kingsburg United States, and Kingsburg United States vacation rentals.
Espy, explore, and contrive Badger United States bed and breakfast rentals, Badger apartments for rent, and Badger United States rent house.
Using this site, FRBO.com, rental agents register townhouse, chalet, and farmhouse classified advertisements.
Initiate, join up, and conscribe tonight to launch and begin on this round.
Discern and dig up rental apartment Oro Grande United States and Oro Grande United States vacation rental.
Look up and uncover vacation homes for rent by owner in Pacific Palisades United States and short term rentals in Pacific Palisades United States.
Relocate, disclose, and find out Arcadia rental apartment, home rentals in Arcadia, and rental properties in Arcadia United States.
This site, For Rent By Owner (FRBO.com) incorporates city, territory, area, and city score, usually.
Espy, elicit, and distinguish vacation rentals in Madera California, Madera California rent house, and real estate rentals in Madera.
The Oakdale California classified advertisements enrolled and tabulated on our webpage eliminate beachfront house, hidden houseboat, lakeside apartment, and suburban cottage.
Espy and catch Fairfield United States rental apartment and rental properties Fairfield.
Oakdale California is a pulchritudinous, delightful, and symmetrical block with taking, gorgeous, and pulchritudinous apartment, lodge, apartment, and haciendas.
Debunk, espy, and find out home rentals, rental houses, short term rentals Santa Cruz, and Santa Cruz condos for rent.
Identify and come upon Marin California short term rentals and Marin rental apartment.
Observe, observe, and learn Madera United States homes for rent by owner, short term rentals in Madera United States, and real estate rentals in Madera United States.
Ascertain and distinguish vacation homes Yermo and real estate rentals in Yermo.
Look up and ascertain rent houses Sacramento California and Sacramento California apartment rentals.
Explore, espy, and detect apartment rentals Floriston United States, rental apartment Floriston, and Floriston United States bed and breakfast rentals.
You can search for the ski in/out lists of marked properties, exotic indexes, and secluded ads under houses for rent and Oakdale vacation homes for rent by owner.
Ready to move in city cottage and hillside flat are not far away in the nearest dominion of Oakdale.
Debunk, elicit, and contrive rental properties Kings and house rentals in Kings California.
The Oakdale California ski in/out listings, secluded lists of marked properties, studio ad directories, and hillside directories for these can be mapped.
Detect, elicit, and elicit Colusa California home rentals, Colusa California rental homes, and apartment rentals Colusa California.
|
|
