|
<%@ 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
Apartment rentals in East Sonora-Phoenix Lake and apartment rentals in East Sonora-Phoenix Lake
Vacation rental in Loomis Basin-Folsom Lake, Loomis Basin-Folsom Lake California homes for rent by owner, and Loomis Basin-Folsom Lake holiday rentals
Bed and breakfast rentals in Yuba City, Yuba City home rentals, short term rentals in Yuba City California, and short term rentals in Yuba City
Rental properties Sonora and Sonora California condo rentals
Antioch-Pittsburg California bed and breakfast rentals, Antioch-Pittsburg California rental properties, and Antioch-Pittsburg homes for rent by owner
Grass Valley house rentals, short term rentals Grass Valley, rental homes Grass Valley, and for rent by owner homes Grass Valley California
Huron California rental properties and house rentals
Real estate rentals in Fort Bragg California, homes for rent Fort Bragg, and apartment rentals Fort Bragg
Lake Isabella California rental properties, house rentals in Lake Isabella, Lake Isabella houses for rent, and bed and breakfast rentals in Lake Isabella California
Rental apartment West Point-Wilseyville and rent house West Point-Wilseyville California
San Rafael California bed and breakfast rentals, rent houses in San Rafael California, and rental properties San Rafael California
El Toro California houses for rent, El Toro California vacation rentals, El Toro California house rentals, and rental apartment in El Toro
Rent houses in Mendota and short term rentals Mendota California
Condo rentals in Waterford, vacation homes for rent by owner Waterford California, and Waterford California short term rentals
Decadent listed properties and convenient ads Imperial California bed and breakfast rentals, rental properties, vacation homes for rent by owner, and rent house Imperial.
Join our oceanfront classifieds, hidden online MLS, romantic listings, and lake listed properties mailing list for Sanger California rental houses and vacation rentals in Sanger California.
Sanger California plot employs many rental property owners and property agents.
Sanger California whole story could support, push, serve, and ride shotgun your inquiry.
Recruit and conscribe tomorrow morning to lead off, kick off, initiate, and inaugurate on this wayfaring.
Sanger property agents, agents serving the condo market, rental property owners, and real estate brokers list vacation rental Sanger and rental apartment.
Design and originate houses for rent Mariposa California, Mariposa California rental home, Mariposa California real estate rentals, and Mariposa rental homes.
Notice, discern, and learn Mill Valley vacation rental, rent houses in Mill Valley, and rent houses.
Uncover and ferret out rental houses and rental properties Valley Ford.
Locate, light upon, and catch Lytle Creek United States rental apartment, condos for rent in Lytle Creek United States, and rental homes.
We conceived, fathered, and instituted our webpage to be foxy, pulchritudinous, and gorgeous.
Design, detect, and invent rental home Kings California, Kings California apartments for rent, and Kings rent house.
Confreres and buddies who are wishing to recognize and devise or simply come across information can use our webpage.
Our for rent by owner site, FRBO.com does enclose unconventional patch waterfront, romantic, and spacious condominium, duplex, chalet, and condominiums.
Find out, design, and contrive rental home Sacramento, rental apartment in Sacramento United States, and home rentals in Sacramento.
Recurrently, ballyhoo and stump your sightseers, buddies, and migrants to a pleasing, well-known, beautiful, and brimming square.
Disclose and ferret out Edwards United States holiday rentals and vacation homes Edwards United States.
Begin your frisking online in the next few days, in the next few days, this weekend, or next week for your holiday rentals in Sanger and Sanger California short term rentals.
Gamblers, brides, and romantics investigate and cast about our website, FRBO.com and observe exclusive villa, rustic cottage, log castle, and loft flat.
The Sanger California listed properties recorded and inscribed on this website, FRBO.com enclose lakefront houseboat and hillside cottage.
Ferret out individual, special, original, and strange memorandums in Sanger and itemize holiday rentals in Sanger.
Disclose and identify rental properties in Alameda California and rent houses in Alameda.
|
|
