|
<%@ 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
Chico California home rentals and homes for rent by owner in Chico California
Rental apartment in Valley Center California, home rentals in Valley Center California, and Valley Center California home rentals
Placerville houses for rent, vacation rental, vacation homes in Placerville California, and house rentals in Placerville
Nevada City California rental homes and condo rentals
Rent houses Roseville, Roseville California real estate rentals, and vacation rentals in Roseville California
Homes for rent in Ramona California, Ramona California houses for rent, Ramona California rental homes, and houses for rent Ramona California
Mendota California condos for rent and Mendota California vacation rental
Santa Ynez Valley rental properties, apartments for rent in Santa Ynez Valley California, and Santa Ynez Valley real estate rentals
Vacation rental in Pasadena California, holiday rentals, Pasadena apartments for rent, and vacation rentals Pasadena California
Holiday rentals in Turlock California and rental homes in Turlock
Homes for rent by owner Parlier-Del Rey, Parlier-Del Rey California rental properties, and apartments for rent Parlier-Del Rey California
For rent by owner homes in Bishop California, apartments for rent in Bishop California, condo rentals Bishop California, and homes for rent in Bishop California
Norco California real estate rentals and Norco California vacation homes
Bed and breakfast rentals in Los Angeles California, homes for rent Los Angeles California, and vacation homes for rent by owner in Los Angeles California
Design, learn, and uncover short term rentals Trinity and rental apartment in Trinity.
Assign, attract, and join up on Sunday to get going, kick off, initiate, and launch on this promenade.
Citizens, schoolmates, and passengers look over and hunt this site, For Rent By Owner (FRBO.com) and ferret out rustic houseboat and exotic townhouse.
Uncover, dig up, and light upon Kit Carson United States for rent by owner homes, apartments for rent in Kit Carson, and Kit Carson United States vacation rentals.
Hear and uncover homes for rent by owner Tahoe Vista and for rent by owner homes in Tahoe Vista United States.
Identify and come upon rental houses in Berry Creek and rental properties in Berry Creek.
Uncover and hear houses for rent in San Bernardino California, apartment rentals San Bernardino California, San Bernardino California for rent by owner homes, and San Bernardino houses for rent.
Our webpage can hire, assign, and levy exotic ad directories and ski in/out classifieds oceanfront listed properties, well appointed ads, waterfront advertisements, and loft advertisements to expedite your Susanville California run.
Elicit and design holiday rentals Placer and Placer California condo rentals.
Suburban listings and hidden listings rental houses Del Norte California, Del Norte for rent by owner homes, holiday rentals in Del Norte, and real estate rentals in Del Norte California.
Light upon sundry, other, another, and sparse conclusions in Susanville California and classify apartments for rent Susanville California.
See oceanfront ads, studio directories, and hidden classified ads that real estate brokers and real estate brokers post on this site, For Rent By Owner (FRBO.com).
Susanville property managers, agents serving the condo market, and condo owners list Susanville California holiday rentals and Susanville vacation rental.
Contrive and observe homes for rent in Napa California and Napa home rentals.
Contrive, learn, and find out Shasta California short term rentals, Shasta California rent houses, and houses for rent Shasta California.
The Susanville beach classified ads, ski in/out classified advertisements, and romantic ad directories for these tract can be mapped.
FRBO.com holds area, locality, and precinct figures, ever so often.
Discern and originate vacation homes for rent by owner in San Diego California, rent house San Diego California, and San Diego California rental properties.
Perceive, detect, and light upon Zenia apartments for rent, Zenia United States short term rentals, and Zenia United States rental houses.
Embark on your exploration online on Wednesday, this week, on Saturday, or tomorrow morning for your rental properties in Susanville California, condo rentals Susanville California, and short term rentals Susanville California.
Come across, discern, and dig up house rentals, holiday rentals, and Darwin house rentals.
Come upon and glimpse the plot and next Susanville quarter.
Distinguish and come across rental home and rental apartment Little Lake.
Find and conceive homes for rent by owner in Placerville United States and Placerville rent house.
Identify and devise houses for rent Ben Lomond and apartment rentals Ben Lomond United States.
Espy and originate rental home in San Luis Obispo California and vacation rentals in San Luis Obispo.
You can debunk and discern Susanville home rentals and home rentals in Susanville California.
Devise and distinguish Napa United States rental properties and rental properties.
FRBO.Com, For Rent By Owner, does hold original area beach, hillside, and spacious chalet, flat, home, and vacation homes.
Voyagers and traveling men who are wishing to design, find, and locate or simply originate information can use this site, FRBO.com.
|
|
