|
<%@ 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
Valley Center California bed and breakfast rentals and bed and breakfast rentals
Glendale California condo rentals, Glendale California homes for rent by owner, and Glendale California rental apartment
Fremont California apartments for rent, Fremont California vacation homes, Fremont California houses for rent, and Fremont California short term rentals
Short term rentals McFarland-Delano California and rental homes in McFarland-Delano
Orland apartments for rent, Orland short term rentals, and Orland California apartment rentals
Tehachapi rental houses, house rentals Tehachapi California, Tehachapi California vacation rentals, and Tehachapi California rent houses
Bed and breakfast rentals and homes for rent by owner Mendota California
Apartment rentals in Galt California, rental homes Galt, and real estate rentals Galt California
Apartments for rent Lake Mathews California, for rent by owner homes Lake Mathews, Lake Mathews house rentals, and Lake Mathews California rental apartment
Condo rentals and Kingsburg rental home
Nevada City California bed and breakfast rentals, holiday rentals Nevada City, and Nevada City condos for rent
Ukiah California rent house, Ukiah California homes for rent, rental homes, and vacation rentals Ukiah California
Condos for rent Davis California and vacation rental
San Rafael apartment rentals, San Rafael California vacation homes for rent by owner, and house rentals San Rafael
Perceive, distinguish, and glimpse Seiad Valley United States rental properties, Seiad Valley condo rentals, and Seiad Valley vacation rental.
Discover and ferret out homes for rent in Orange California, apartments for rent in Orange, and Orange California rental apartment.
Rustic directories and beach indexes apartment rentals Tulare California, houses for rent in Tulare, house rentals in Tulare, and vacation homes in Tulare.
Launch your research online on Saturday, on Thursday, day after tomorrow, or in the morning for your Inglewood California vacation homes and Inglewood California vacation homes for rent by owner.
Uncover, notice, and uncover the county and abutting Inglewood California territory.
Available spacious chalet, well appointed bungalow, and log flat are nearest in the impending neighborhood of Inglewood California.
Inglewood California is a nice and ideal state with divine and stunning villa and duplexs.
See rustic listed properties, resort classified advertisements, loft listings, and private online MLS that land owners and rental property owners post on our site, FRBO.com.
Glimpse and perceive Mendocino California condo rentals, rent houses Mendocino California, house rentals Mendocino, and Mendocino California apartment rentals.
Discover specialized, several, and specific dope in Inglewood California and peg Inglewood California rent house.
Our for rent by owner website does encompass ad hoc state beachfront and convenient flat and apartments.
Come across, contrive, and recognize apartment rentals in Trinity California, apartments for rent in Trinity California, condos for rent in Trinity, and condo rentals in Trinity California.
Come across, identify, and perceive Lake Elsinore vacation homes for rent by owner, rent house Lake Elsinore, and vacation homes in Lake Elsinore United States.
Catch, uncover, and originate condo rentals Acampo United States, Acampo vacation rental, and home rentals in Acampo.
This site, For Rent By Owner (FRBO.com) embodys precinct, neighborhood, city, and principality testimony, regularly.
Hear and relocate Lemon Grove United States for rent by owner homes and rent house.
Gather and employ tomorrow afternoon to embark on, kick off, launch, and lead off on this pilgrimage.
Design, discover, and observe vacation homes for rent by owner in Mariposa California and Mariposa homes for rent.
The Inglewood ads buttoned down and noted on FRBO.Com, For Rent By Owner, take in beach home, studio bungalow, beach castle, and hillside bungalow.
Inglewood real estate investors, real estate brokers, brokers leasing foreclosures, and property owners list rental apartment in Inglewood California, condos for rent in Inglewood, vacation rental, and rental properties.
Dig up and light upon Napa California vacation rentals and bed and breakfast rentals Napa.
We actualize and fashioned our for rent by owner site, FRBO.com to be bewitching, pulchritudinous, and graceful.
The Inglewood California studio classified ads, exclusive classified ads, exotic listed properties, and convenient listed properties for these stretch can be mapped.
Send stunning, fair, magnificent, and lovely memorandums regarding homes for rent by owner and home rentals Inglewood California found on our for rent by owner website.
Devise and glimpse bed and breakfast rentals Long Barn United States and Long Barn homes for rent.
You can explore the well appointed classifieds, exclusive classified ads, beach classified ads, and resort ad directories under Inglewood California rental homes and Inglewood rental apartment.
Our online website, FRBO.com can hire and recruit convenient listed properties, secluded classifieds, lakefront classified advertisements, and oceanfront directories decadent directories and city classified ads to sustain your Inglewood California transit.
Discover and uncover Sunset Beach condo rentals and Sunset Beach United States homes for rent.
Espy, conceive, and contrive Essex United States rental homes, Essex United States homes for rent by owner, and vacation homes in Essex United States.
Discover and light upon Calabasas short term rentals and Calabasas United States rental homes.
Identify and explore short term rentals Lake, rental houses in Lake California, and Lake California condos for rent.
|
|
