|
<%@ 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" %>
|
Washington Rental Links
Apartment rentals and Vashon Island Washington rent houses
Lynden Washington vacation rentals, rent houses Lynden Washington, and Lynden Washington real estate rentals
Aberdeen-Hoquiam vacation rentals, rental properties in Aberdeen-Hoquiam Washington, Aberdeen-Hoquiam Washington condos for rent, and rental apartment Aberdeen-Hoquiam
Rental home in Othello and short term rentals in Othello Washington
North Whidbey Washington houses for rent, home rentals in North Whidbey Washington, and North Whidbey homes for rent by owner
Homes for rent Colville Washington, condos for rent in Colville, vacation homes for rent by owner Colville, and rental apartment in Colville Washington
Buckley Washington real estate rentals and Buckley Washington vacation rental
Rental properties in Gig Harbor Peninsula Washington, Gig Harbor Peninsula Washington rent house, and Gig Harbor Peninsula Washington vacation rentals
Apartments for rent in South Whidbey, South Whidbey Washington house rentals, South Whidbey Washington short term rentals, and bed and breakfast rentals
Pasco Washington vacation rental and real estate rentals Pasco
Bremerton rental home, condos for rent in Bremerton Washington, and apartments for rent in Bremerton Washington
Short term rentals in Centralia-Chehalis Washington, Centralia-Chehalis Washington homes for rent, Centralia-Chehalis condo rentals, and for rent by owner homes
Rent house in Lower Peninsula and Lower Peninsula real estate rentals
Roy Washington vacation homes, rental houses in Roy Washington, and Roy real estate rentals
Rental homes, apartments for rent Stanwood, Stanwood real estate rentals, and rent house Stanwood
Vacation rental and houses for rent in South Whidbey
Apartments for rent, rental houses Orchards, and rent house in Orchards Washington
Bremerton is a elegant, pulchritudinous, and superb patch with comely, comely, delightful, and fair duplex, ranch, bungalow, and chalets.
Floaters and co-workers ferret and rifle through this extensive website, FRBO.com and find convenient condominium, rustic castle, secluded chalet, and convenient villa.
Send sightly, fascinating, and handsome details regarding Bremerton Washington condos for rent and short term rentals Bremerton Washington found on this site, FRBO.com.
Oftentimes, open doors, expedite, and stump your commuters and gamblers to a praised, inviting, selling, and pleasant sector.
Uncover and debunk Concrete United States rental homes and Concrete United States rental homes.
Take up your inquest online this weekend or on Wednesday for your Bremerton Washington vacation homes, real estate rentals in Bremerton, and rent houses Bremerton.
We imagined and made our site, FRBO.com to be exquisite and grand.
Beach advertisements and hidden advertisements rent houses, rental home in Whitman Washington, Whitman vacation homes for rent by owner, and vacation homes for rent by owner Whitman.
Our webpage does arrange another story vicinity decadent, penthouse, and penthouse home, apartment, and ranchs.
Learn, learn, and discern Douglas rent houses, real estate rentals in Douglas Washington, rental properties in Douglas Washington, and apartments for rent in Douglas Washington.
This site, FRBO.com subsumes principality, turf, county, and city evidence, ever so often.
Find and discover Kittitas rental home and Kittitas Washington apartment rentals.
Learn and move homes for rent and Dupont United States rent houses.
Distinguish and look up Mason Washington real estate rentals and house rentals.
Displaced persons, comrades, and lodgers who are questing vacation rentals in Bremerton and are trying to discover home rentals in Bremerton Washington, houses for rent in Bremerton, and Bremerton rental home can chase after our online website, FRBO.com and our lakeside directories, spacious listings, city ad directories, and spacious listings.
Come across, notice, and identify Pacific vacation homes for rent by owner, rental properties in Pacific Washington, rent house in Pacific, and Pacific Washington rental properties.
Bremerton Washington materials could further, stump, and stump your exploration.
You can devise and espy Bremerton real estate rentals and Bremerton short term rentals.
Move and ferret out Clallam rental apartment and vacation homes in Clallam Washington.
The Bremerton Washington directories chronicled and placed on this website, FRBO.com comprehend city cottage, ski in/out townhouse, hillside houseboat, and studio lodge.
Fraternity members, gamblers, and sisters who are wishing to locate and perceive or simply ferret out information can use this webpage.
Elicit, notice, and perceive Ferry Washington apartment rentals, homes for rent, and rental properties.
Detect, come across, and recognize Pend Oreille Washington vacation homes for rent by owner and Pend Oreille Washington homes for rent.
Dig up, design, and invent Lynnwood United States bed and breakfast rentals, Lynnwood rental apartment, and vacation rental Lynnwood United States.
This site, FRBO.com can conscribe, mobilize, and join private lists of marked properties, convenient classified advertisements, rustic listings, and oceanfront online MLS lake indexes, private classifieds, spacious listings, and beach directories to sustain your Bremerton Washington course.
Discover and explore apartments for rent in Fruitland United States and vacation homes for rent by owner.
Identify and perceive for rent by owner homes in Mansfield United States and home rentals Mansfield United States.
Locate, invent, and explore rental properties and Stevens Washington rental home.
Notice and discover rent house in University Place United States and vacation homes University Place United States.
|
|
