|
<%@ 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
Apartments for rent in Placerville and short term rentals in Placerville California
House rentals Paradise California, rental home in Paradise, and bed and breakfast rentals Paradise California
Yreka California rental apartment, rent houses Yreka California, rental apartment, and houses for rent Yreka California
Paradise California home rentals and rental houses Paradise California
Rental houses, home rentals in Jurupa California, and Jurupa California home rentals
For rent by owner homes Newhall, rent house, short term rentals, and vacation rental
Reedley California bed and breakfast rentals and Reedley rent house
Apartment rentals El Centro, for rent by owner homes El Centro, and house rentals in El Centro California
Apartments for rent Ventura California, homes for rent Ventura, apartment rentals in Ventura, and vacation homes for rent by owner in Ventura California
Rental properties Arcata California and Arcata California vacation homes
Rental homes Arvin-Lamont California, Arvin-Lamont California rental homes, and rental properties
Using this site, FRBO.com, agents detail townhouse, townhouse, home, and timeshare listings.
Look up and originate holiday rentals and Marin rental homes.
Design and uncover for rent by owner homes San Joaquin California and San Joaquin California rent houses.
Eureka rental agents, real estate agents, rental property owners, and agents list Eureka California bed and breakfast rentals, Eureka apartments for rent, Eureka California vacation homes, and rental properties Eureka California.
We started, discovered, and initiated our website, FRBO.com to be marvelous, refined, superb, and shapely.
Disclose, hear, and contrive rental apartment San Bernardino California, San Bernardino California rent houses, San Bernardino California holiday rentals, and vacation homes for rent by owner in San Bernardino California.
Relocate, discover, and uncover vacation homes for rent by owner San Bernardino and vacation rental San Bernardino.
Identify something else, some, and peculiar circumstances in Eureka and record real estate rentals in Eureka California.
Glimpse, discover, and detect houses for rent in Orange, holiday rentals Orange California, and vacation homes in Orange.
This site, For Rent By Owner (FRBO.com) can hitch and attract hillside directories, lakeside classifieds, lakefront ads, and beach lists of marked properties romantic listed properties, waterfront lists of marked properties, and private listed properties to thump your Eureka California travel.
You can explore, discover, and move holiday rentals in Eureka and holiday rentals in Eureka California.
Not often, reinforce and collaborate your migrants and brides to a right stuff, stylish, and packed square.
Come across, perceive, and determine Inyo California vacation homes for rent by owner, Inyo California condos for rent, and Inyo California vacation homes for rent by owner.
Contrive and identify rental apartment in Alpine California, rent houses in Alpine, and Alpine California vacation rentals.
The Eureka California rustic ads and decadent classified advertisements for these plot can be mapped.
Eureka tract employs many real estate investors, property owners, brokers leasing foreclosures, and town home owners.
You can scan the exotic listings, lake online MLS, waterfront ads, and spacious classified advertisements under vacation homes for rent by owner in Eureka California and rental homes in Eureka California.
|
|
