|
<%@ 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
Vacation homes and house rentals in Puyallup
Vacation homes for rent by owner, rental houses, and holiday rentals Olympia Washington
Rent house Pasco Washington, Pasco Washington apartment rentals, Pasco Washington holiday rentals, and Pasco Washington apartment rentals
Condo rentals in Tacoma and homes for rent by owner in Tacoma Washington
Southern Slopes Washington rental properties, house rentals in Southern Slopes, and Southern Slopes apartment rentals
Vacation homes for rent by owner in East Seattle Washington, East Seattle Washington condo rentals, short term rentals, and East Seattle Washington home rentals
Rental homes in Gig Harbor Peninsula and vacation homes in Gig Harbor Peninsula Washington
Bed and breakfast rentals in Yakima, Yakima Washington apartments for rent, and rental properties
Rental home, Southern Slopes homes for rent, home rentals Southern Slopes, and real estate rentals in Southern Slopes Washington
North Whidbey holiday rentals and North Whidbey short term rentals
Apartments for rent, apartments for rent in South Shore, and South Shore Washington short term rentals
Bed and breakfast rentals, Seattle apartment rentals, rental properties in Seattle Washington, and home rentals in Seattle Washington
Home rentals Moses Lake and Moses Lake Washington condos for rent
Rental houses in Camas, rental homes Camas Washington, and holiday rentals in Camas
Rent houses in Burlington Washington, rental houses in Burlington, for rent by owner homes, and Burlington Washington apartments for rent
Bed and breakfast rentals in Sunnyside and Sunnyside holiday rentals
Using our for rent by owner site, FRBO.com, real estate brokers docket chalet, bungalow, apartment, and farmhouse indexes.
Conceive, determine, and come upon Moxee United States condos for rent, rental properties in Moxee United States, and condo rentals in Moxee United States.
Elicit, uncover, and distinguish house rentals, rent house, for rent by owner homes in Skamania Washington, and Skamania Washington rent houses.
The Snoqualmie Valley Washington listings registered and ticked off on this webpage subsume secluded duplex, ski in/out cabin, ski in/out apartment, and beach lodge.
Relocate and learn rental homes in Entiat and rental apartment Entiat United States.
Discern, come across, and look up Lincoln Washington bed and breakfast rentals and Lincoln Washington home rentals.
Our for rent by owner website involves parcel, locality, quarter, and domain info, now and again.
Snoqualmie Valley Washington is a ravishing and nice precinct with handsome, symmetrical, resplendent, and marvelous house, villa, and timeshares.
We designed, generated, and phrased our page to be fascinating, grand, and statuesque.
Notice, discern, and hear Columbia rental apartment, rental homes in Columbia Washington, and Columbia Washington apartment rentals.
Sisters and journeyers who are wishing to design, observe, and discover or simply learn information can use For Rent By Owner.
Uncover several and atypical goods in Snoqualmie Valley and tab holiday rentals in Snoqualmie Valley Washington.
Glimpse and conceive Thurston Washington short term rentals, home rentals Thurston, rental houses Thurston Washington, and Thurston condos for rent.
Discover, perceive, and glimpse rental properties in Seaview, short term rentals in Seaview United States, and bed and breakfast rentals in Seaview.
Catch and discover vacation homes for rent by owner Pend Oreille Washington, homes for rent by owner in Pend Oreille, and Pend Oreille short term rentals.
Devise, dig up, and ferret out rental home Peshastin, house rentals Peshastin United States, and Peshastin United States condos for rent.
Glimpse and ascertain rental houses in Mountlake Terrace United States and rental home in Mountlake Terrace.
Join our rustic ad directories, beach ad directories, and romantic lists of marked properties mailing list for short term rentals in Snoqualmie Valley Washington and vacation homes for rent by owner in Snoqualmie Valley Washington.
You can perceive, catch, and conceive Snoqualmie Valley Washington for rent by owner homes, vacation homes for rent by owner, and condos for rent.
FRBO.com can appoint, incorporate, and call up loft indexes and exclusive ads secluded advertisements, penthouse ad directories, suburban ads, and studio lists of marked properties to expedite your Snoqualmie Valley migration.
Debunk, come upon, and ascertain rental apartment in Franklin Washington, vacation homes in Franklin Washington, and apartment rentals in Franklin Washington.
See convenient online MLS, spacious ad directories, ski in/out listed properties, and penthouse directories that agents serving the condo market and property agents post on this extensive website, FRBO.com.
|
|
