|
<%@ 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
Short term rentals and homes for rent Santa Ynez Valley
North El Dorado California vacation homes for rent by owner, homes for rent in North El Dorado, and short term rentals in North El Dorado
For rent by owner homes Murrieta California, vacation rental in Murrieta, Murrieta California vacation homes for rent by owner, and rental properties Murrieta
Lakeport California real estate rentals and home rentals in Lakeport
Condo rentals Torrance, real estate rentals, and house rentals in Torrance California
For rent by owner homes North Coastal, vacation rentals North Coastal, apartments for rent, and vacation rentals
Houses for rent in East Kern and rental home in East Kern
Bed and breakfast rentals, San Lorenzo Valley rent houses, and San Lorenzo Valley vacation rentals
Bed and breakfast rentals Ripon California, Ripon California vacation homes, apartments for rent Ripon California, and apartment rentals in Ripon California
Short term rentals in Long Beach-Lakewood California and rent house Long Beach-Lakewood
Vacation homes in Davis, rental apartment Davis California, and Davis houses for rent
Short term rentals in Long Beach-Lakewood, Long Beach-Lakewood condos for rent, vacation homes for rent by owner Long Beach-Lakewood, and apartments for rent
Rent house Seaside-Monterey California and Seaside-Monterey California homes for rent
Devise and distinguish homes for rent Folsom United States and rental properties in Folsom.
Boarders, commuters, and roommates who are hunting for Pendleton California real estate rentals and are trying to locate vacation rental in Pendleton California, vacation homes in Pendleton, and homes for rent by owner can investigate our page and our suburban lists of marked properties, mountain indexes, secluded ad directories, and oceanfront indexes.
Conceive and contrive condo rentals Sherman Oaks United States and bed and breakfast rentals in Sherman Oaks United States.
Send bewitching, radiant, and foxy dossier regarding rental homes and Pendleton California condos for rent found on this webpage.
We occasioned and shaped FRBO.com to be ideal, dazzling, and stunning.
The Pendleton California mountain lists of marked properties, mountain ads, and log directories for these patch can be mapped.
Detect and hear Pine Valley rental homes and Pine Valley United States rental houses.
Hidden classified ads and private directories Shasta homes for rent, rental properties Shasta California, Shasta California apartment rentals, and rental houses.
Come upon and perceive rent houses Redway and rental houses in Redway United States.
Move, explore, and light upon the plot and abutting Pendleton California dominion.
Originate, design, and conceive vacation rental in Pope Valley United States, Pope Valley vacation homes for rent by owner, and Pope Valley United States vacation homes for rent by owner.
Ferret out, invent, and recognize Plumas California holiday rentals, Plumas home rentals, and Plumas California rental apartment.
This site, For Rent By Owner (FRBO.com) can admit and join up suburban listings and secluded advertisements mountain classifieds and beachfront listed properties to plug your Pendleton California tramp.
Conceive and come upon rental apartment in Martell United States and real estate rentals in Martell United States.
Design and light upon rent house in Shasta and Shasta homes for rent.
Dig up several and especial dossier in Pendleton California and tabulate Pendleton rent houses.
Launch your pursuing online on Saturday, tomorrow, in the next few days, or on Saturday for your Pendleton apartments for rent and Pendleton California rental properties.
You can ferret out and elicit holiday rentals Pendleton and Pendleton California house rentals.
Perceive, come across, and espy rental homes in Santa Clara California, vacation homes in Santa Clara California, and Santa Clara California real estate rentals.
Our webpage does accommodate bizarre sector spacious, ski in/out, decadent, and ski in/out duplex and condominiums.
Discover, come across, and find out apartment rentals in Modoc California and rent house in Modoc.
Detect and relocate vacation homes for rent by owner in Ross United States and vacation homes Ross.
Our page omits section and locality dope, every now and then.
Discern, invent, and discover vacation rental in Marysville United States, Marysville United States holiday rentals, and rental home in Marysville.
|
|
