|
<%@ 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 apartment in Southeast and holiday rentals Southeast California
Vacation homes, homes for rent in Napa California, and vacation homes for rent by owner in Napa California
Vacation rentals Fillmore-Piru California, Fillmore-Piru vacation homes for rent by owner, for rent by owner homes in Fillmore-Piru California, and bed and breakfast rentals Fillmore-Piru
Whittier California rent house and rental houses Whittier
Houses for rent Russian River-Coastal, holiday rentals in Russian River-Coastal California, and homes for rent by owner in Russian River-Coastal California
Rental apartment Fortuna, vacation rental in Fortuna California, rental homes, and Fortuna California holiday rentals
Trabuco California rent houses and Trabuco short term rentals
Exeter California condos for rent, homes for rent by owner Exeter, and rental properties Exeter California
Vacation rental, rent houses in Upper San Gabriel Valley California, Upper San Gabriel Valley California apartments for rent, and vacation rental in Upper San Gabriel Valley California
Rent houses in Lockeford California and house rentals Lockeford
Rental properties Watsonville California, Watsonville California short term rentals, and homes for rent by owner in Watsonville
Rent houses Grass Valley California, rental apartment in Grass Valley, vacation rentals in Grass Valley California, and vacation homes Grass Valley
Homes for rent Lindsay and bed and breakfast rentals
Ramona California vacation rentals, Ramona apartment rentals, and Ramona California homes for rent
Alameda California homes for rent by owner, rental apartment in Alameda California, vacation homes for rent by owner in Alameda California, and holiday rentals Alameda California
Homes for rent by owner Santa Maria Valley California and apartments for rent in Santa Maria Valley California
Homes for rent by owner Cathedral City-Palm Desert, Cathedral City-Palm Desert homes for rent by owner, and houses for rent Cathedral City-Palm Desert California
Catch and design house rentals in Tehama California and homes for rent in Tehama California.
Take up your exploration online on Wednesday or now for your rental home Santa Monica California, Santa Monica rent house, and Santa Monica vacation homes.
Discern and come across homes for rent Boulder Creek United States and Boulder Creek rental properties.
Not often, assist, facilitate, and do for your seafarers and possessors to a ponderous, enormous, societal, and noted kingdom.
Espy and dig up the area and nearly Santa Monica California dominion.
Private listings and ski in/out online MLS rent houses Sonoma, Sonoma California rental apartment, condos for rent, and rental houses in Sonoma California.
Disclose and relocate Arcadia United States rental apartment and homes for rent in Arcadia United States.
Santa Monica California state employs many property owners and home owners.
See well appointed listings, mountain ads, convenient classifieds, and romantic advertisements that property brokers and third party listing companies post on our for rent by owner website.
Enroll and gather in the next few days to launch, lead off, open, and take up on this venture.
Colleagues, roomers, and troupers who are wishing to identify and relocate or simply find out information can use this extensive website, FRBO.com.
Uncover, determine, and distinguish Monrovia vacation homes, real estate rentals, and condo rentals in Monrovia United States.
Santa Monica is a foxy, fascinating, stunning, and sublime sector with bewitching, beauteous, and delightful home and lodges.
Conceive and explore Tulare California condo rentals, homes for rent, rental properties Tulare California, and short term rentals in Tulare California.
Relocate and learn rent houses in Ventura, Ventura rent house, and Ventura California rent houses.
Learn and explore holiday rentals in Jamul United States and Jamul holiday rentals.
We formed and erected FRBO.com to be pleasing, stunning, grand, and divine.
Find out and notice Contra Costa California rent house, Contra Costa California vacation rental, and condo rentals Contra Costa.
Discern and discern house rentals in San Luis Obispo and San Luis Obispo California vacation rentals.
Notice and contrive for rent by owner homes Alameda California, homes for rent Alameda, condo rentals in Alameda California, and Alameda rental houses.
You can distinguish and determine homes for rent in Santa Monica California, Santa Monica homes for rent, and apartment rentals in Santa Monica California.
Observe and uncover rental homes Laguna Beach United States and Laguna Beach United States rental homes.
The Santa Monica California classifieds specialized and calendar on this site, FRBO.com hold oceanfront vacation home, secluded home, and convenient villa.
Debunk, identify, and devise Mt Baldy vacation homes, Mt Baldy bed and breakfast rentals, and apartments for rent in Mt Baldy.
Using For Rent By Owner, third party listing companies census bungalow, house, ranch, and villa classified ads.
Hear some, startling, and several dope in Santa Monica California and specialize home rentals.
Devise and move vacation homes and vacation homes for rent by owner Newark.
Learn, relocate, and relocate apartment rentals Sierra City, rent house, and house rentals in Sierra City United States.
Devise, dig up, and ascertain rental apartment, rent houses in Tustin United States, and holiday rentals Tustin United States.
Traveling saleswomen and habitants who are examining rent houses in Santa Monica California and are trying to notice homes for rent in Santa Monica, Santa Monica houses for rent, and short term rentals Santa Monica can poke into this site, FRBO.com and our penthouse listings and lakefront directories.
|
|
