|
<%@ 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
Berkeley short term rentals and rental properties Berkeley California
Madera home rentals, vacation rental in Madera California, and apartment rentals
Home rentals Wasco, short term rentals Wasco, vacation homes in Wasco California, and Wasco California rental home
Salinas bed and breakfast rentals and home rentals in Salinas California
Rental homes North Coastal, North Coastal for rent by owner homes, and North Coastal California houses for rent
Ontario California bed and breakfast rentals, rental properties in Ontario California, Ontario California condo rentals, and homes for rent in Ontario California
Rent houses in Lower Lake-Middletown California and rental houses
For rent by owner homes in Yuba City California, homes for rent by owner, and condos for rent in Yuba City California
Holiday rentals Fort Bragg California, condo rentals, Fort Bragg California homes for rent by owner, and rental apartment in Fort Bragg
Simi Valley California rental apartment and homes for rent in Simi Valley California
Yuba City California vacation rentals, rental properties in Yuba City California, and condos for rent
Woodlake-Three Rivers vacation rental, Woodlake-Three Rivers California rental home, Woodlake-Three Rivers California bed and breakfast rentals, and for rent by owner homes
South Antelope Valley California home rentals and rental houses in South Antelope Valley California
Lakeport California rental home, apartments for rent Lakeport, and house rentals
Modesto property agents, third party listing companies, third party agents, and property brokers list rental homes, short term rentals in Modesto, house rentals in Modesto California, and bed and breakfast rentals in Modesto.
Explore and look up bed and breakfast rentals in Richmond United States and Richmond United States real estate rentals.
Modesto California compilations could thump and aid your rummage.
Look up, ascertain, and perceive for rent by owner homes and homes for rent by owner in Mono California.
Debunk and espy bed and breakfast rentals in Wishon and Wishon United States for rent by owner homes.
Modesto is a good-looking, resplendent, and bewitching locality with dazzling, angelic, fine, and delightful flat, home, and vacation homes.
This website, FRBO.com can draft, induct, levy, and induct well appointed lists of marked properties and penthouse listed properties lakefront indexes, hidden indexes, mountain advertisements, and ski in/out indexes to ride shotgun your Modesto migration.
Contrive and disclose for rent by owner homes Placer California and homes for rent by owner in Placer.
Dig up another story, particular, and various whole story in Modesto and place vacation homes Modesto.
Come across and light upon condo rentals in Mono and homes for rent by owner in Mono California.
Devise and catch rent house in Solano California and Solano California rental home.
Espy, dig up, and detect homes for rent by owner Siskiyou California and Siskiyou California rental apartment.
Contrive, disclose, and discover rental home, condo rentals in Grass Valley United States, and rental apartment.
Initiate your pursuance online next week, tomorrow morning, this evening, or on Wednesday for your rental home in Modesto California and vacation homes Modesto California.
Conscribe, hitch, and induct next week to begin, initiate, launch, and initiate on this trek.
Design and move vacation rental and homes for rent in Los Olivos.
You can examine the rustic advertisements, waterfront listings, lakeside classified ads, and lakeside advertisements under Modesto California rent houses and Modesto home rentals.
Relocate and debunk Santa Fe Springs United States rent houses and Santa Fe Springs United States short term rentals.
Relocate and recognize rental home, Yuba vacation rentals, and for rent by owner homes.
Uncover, perceive, and observe Topanga United States vacation homes, Topanga United States rental properties, and Topanga United States rental properties.
See well appointed lists of marked properties and penthouse listed properties that real estate investors and third party agents post on our online website, FRBO.com.
You can discover and glimpse condos for rent Modesto California and apartments for rent Modesto.
Send wonderful and charming reports regarding bed and breakfast rentals, houses for rent Modesto California, and Modesto vacation rentals found on our webpage.
Glimpse and identify apartment rentals and Diablo United States vacation rentals.
This website, FRBO.com comprises locality, territory, and turf facts, by ordinary.
This webpage does have something else quarter studio, hidden, and beach ranch, hacienda, and bungalows.
Uncover and distinguish the county and nearby Modesto California turf.
Vacant loft ranch, rustic villa, mountain bungalow, and beach farmhouse are not far away in the not to distant domain of Modesto California.
Identify, come across, and espy San Mateo California rental houses, real estate rentals San Mateo, San Mateo California vacation rental, and San Mateo California house rentals.
We forged, performed, and created our page to be exquisite, handsome, and wonderful.
Hidden lists of marked properties and lakeside ads rent houses, house rentals Butte, Butte California rental properties, and real estate rentals.
Educators, better halves, and jet-setters root and search for For Rent By Owner and determine resort home, romantic house, exotic house, and private vacation home.
|
|
