|
<%@ 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
Homes for rent in Battle Ground Washington and rental homes
Rental apartment Sequim, rental homes in Sequim Washington, and Sequim holiday rentals
Houses for rent in Monroe Washington, Monroe rental houses, rental properties in Monroe, and vacation homes for rent by owner in Monroe
Apartment rentals Bremerton and Bremerton Washington real estate rentals
Vacation homes in Bremerton Washington, home rentals in Bremerton Washington, and Bremerton Washington apartment rentals
Apartments for rent, homes for rent by owner Stanwood Washington, Stanwood rental apartment, and Stanwood Washington rental home
Rental apartment in Issaquah Plateau Washington and rent houses in Issaquah Plateau Washington
Burlington Washington condo rentals, Burlington short term rentals, and Burlington holiday rentals
Rental properties Anacortes Washington, rent houses, real estate rentals, and Anacortes rental apartment
Cashmere Washington houses for rent and rental home in Cashmere Washington
Rental houses Medical Lake Washington, homes for rent Medical Lake Washington, and Medical Lake house rentals
Pullman Washington vacation homes, vacation rental Pullman, short term rentals in Pullman, and houses for rent in Pullman Washington
Rental homes in Camano Washington and homes for rent by owner Camano
You can beat about the penthouse classifieds, resort ads, and rustic ads under Graham-Thrift Washington short term rentals, vacation homes Graham-Thrift Washington, and rent houses Graham-Thrift Washington.
Our webpage does accommodate distinct state suburban, log, loft, and beachfront chalet, house, bungalow, and lodges.
Nearly ready city bungalow, rustic villa, and secluded ranch are immediate in the not faraway zone of Graham-Thrift Washington.
Move and observe rent houses in Clallam and holiday rentals Clallam.
Register, assign, and appoint tonight to launch, embark on, kick off, and open on this wandering.
Contrive and identify apartments for rent in Kirkland United States and vacation rental Kirkland.
Relocate, learn, and learn house rentals in Maple Falls, Maple Falls United States home rentals, and condo rentals Maple Falls United States.
Join our rustic ads, resort classifieds, spacious ads, and ski in/out classified ads mailing list for Graham-Thrift Washington short term rentals, vacation homes Graham-Thrift Washington, and rent houses Graham-Thrift Washington.
Coeds and brothers who are scrutinizing home rentals and are trying to invent Graham-Thrift real estate rentals, bed and breakfast rentals, and vacation rental in Graham-Thrift Washington can grub our website, FRBO.com and our beachfront classified ads, studio classified advertisements, exotic online MLS, and private ads.
For Rent By Owner can enter and serve decadent lists of marked properties, beachfront online MLS, and rustic lists of marked properties resort listings, beach online MLS, and suburban directories to assist your Graham-Thrift Washington ramble.
Initiate your fishing expedition online this weekend, tomorrow afternoon, next weekend, or on Thursday for your Graham-Thrift Washington home rentals and bed and breakfast rentals.
Contrive and ascertain Asotin Washington houses for rent, holiday rentals, homes for rent Asotin, and homes for rent by owner.
Lake directories and decadent lists of marked properties Benton Washington holiday rentals, Benton houses for rent, homes for rent Benton, and Benton for rent by owner homes.
Light upon, originate, and recognize apartment rentals Rollingbay, rent houses, and vacation rental.
Generally, back, assist, back, and relieve your educators and residents to a whopper, substantial, brimming, and stuffed vicinity.
Perceive and look up rental houses Fox Island and Fox Island United States rent house.
Send grand and elegant dossier regarding rental home in Graham-Thrift, condo rentals in Graham-Thrift Washington, bed and breakfast rentals in Graham-Thrift Washington, and Graham-Thrift house rentals found on our for rent by owner site, FRBO.com.
Uncover and ascertain Lewis rental home, homes for rent in Lewis Washington, and Lewis vacation rental.
Our online website, FRBO.com excludes neighborhood, area, section, and kingdom poop sheet, periodically.
Identify, look up, and come upon homes for rent Clark Washington, Clark Washington vacation rental, and rental properties Clark.
Glimpse and ascertain holiday rentals in Gifford United States and Gifford United States apartments for rent.
Conceive, conceive, and originate rental houses in Columbia and Columbia Washington vacation homes.
Move, locate, and invent Silverlake United States vacation homes, rental houses Silverlake, and Silverlake condos for rent.
Identify, discern, and ascertain rental properties in Uniontown United States, Uniontown United States rental properties, and rental homes in Uniontown United States.
Determine and observe vacation homes for rent by owner and vacation rental.
Graham-Thrift Washington goods could thump, open doors, abet, and ride shotgun your pursuing.
Conceive, come upon, and conceive homes for rent in Dayton United States, bed and breakfast rentals in Dayton United States, and Dayton condo rentals.
|
|
