|
<%@ 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
Tahoma-Maple Valley holiday rentals and rental homes in Tahoma-Maple Valley
Apartments for rent in Puyallup Washington, Puyallup Washington vacation homes, and rent house
Homes for rent by owner Northwest Benton Washington, apartment rentals in Northwest Benton Washington, vacation rental Northwest Benton, and rental homes Northwest Benton
For rent by owner homes in Sedro-Woolley and Sedro-Woolley Washington short term rentals
Northwest Benton holiday rentals, Northwest Benton apartments for rent, and condos for rent Northwest Benton Washington
Vacation homes for rent by owner Mount Vernon, Mount Vernon Washington rental apartment, apartments for rent in Mount Vernon Washington, and Mount Vernon Washington apartments for rent
Vacation homes in Olympia Washington and Olympia Washington holiday rentals
Rental home in South Shore Washington, South Shore Washington condo rentals, and rental apartment
Rental properties, rental homes in Clarkston Washington, homes for rent by owner in Clarkston Washington, and rental properties Clarkston Washington
Vacation rental and Vashon Island Washington homes for rent
Olympia West homes for rent, vacation rental, and rental homes
Real estate rentals La Center Washington, home rentals in La Center Washington, La Center apartments for rent, and La Center Washington vacation rentals
Rental home in Snoqualmie Valley Washington and homes for rent in Snoqualmie Valley Washington
Roy rental apartment, condo rentals Roy Washington, and homes for rent by owner Roy Washington
Vacation rentals Port Angeles Washington, Port Angeles Washington vacation rentals, homes for rent by owner Port Angeles Washington, and Port Angeles Washington apartments for rent
Vashon Island rent house and house rentals in Vashon Island Washington
Tacoma for rent by owner homes, short term rentals Tacoma, and houses for rent
Rental houses in Tahoma-Maple Valley, rental properties Tahoma-Maple Valley Washington, vacation homes for rent by owner Tahoma-Maple Valley Washington, and vacation rentals
Snohomish Washington for rent by owner homes and rental home
House rentals in Port Angeles, rental houses in Port Angeles Washington, and vacation homes for rent by owner
Liberty Lake Washington home rentals, home rentals, for rent by owner homes Liberty Lake Washington, and rent house Liberty Lake
Condo rentals in Maltby Washington and bed and breakfast rentals Maltby
Snoqualmie Valley Washington home rentals, rental homes in Snoqualmie Valley, and Snoqualmie Valley homes for rent by owner
Real estate rentals in Vancouver Washington, for rent by owner homes Vancouver Washington, homes for rent by owner in Vancouver, and Vancouver vacation homes for rent by owner
House rentals in Aberdeen-Hoquiam and rent house Aberdeen-Hoquiam Washington
Condo rentals in Camas Washington, rent houses in Camas Washington, and Camas Washington vacation rental
Condos for rent in Blaine, rental homes Blaine Washington, rent house in Blaine Washington, and bed and breakfast rentals Blaine Washington
Apartment rentals Anacortes Washington and rent house Anacortes
Rent houses, rental properties, and house rentals Centralia-Chehalis Washington
You can identify, recognize, and debunk South Whidbey Washington short term rentals and South Whidbey rental properties.
Find out, identify, and elicit bed and breakfast rentals in Burley, bed and breakfast rentals Burley, and houses for rent.
Debunk, disclose, and discern homes for rent Graham United States, vacation homes in Graham, and for rent by owner homes.
South Whidbey Washington is a beauteous and fascinating square with bewitching, cute, appealing, and delightful condominium and duplexs.
By ordinary, abet, support, support, and push your friends, citizens, and brothers-in-law to a good-looking and pleasing territory.
Relocate, invent, and detect homes for rent by owner in Skagit, Skagit for rent by owner homes, and rental houses Skagit.
Glimpse and recognize vacation rental in Southworth United States and rental home Southworth.
Espy and perceive holiday rentals in Spokane Washington and Spokane Washington rental homes.
Conceive, find out, and debunk San Juan Washington vacation rentals and San Juan condo rentals.
South Whidbey property owners and third party agents list South Whidbey Washington condos for rent and home rentals in South Whidbey.
Light upon, recognize, and hear vacation rentals, homes for rent by owner in Richland United States, and apartments for rent.
This site, For Rent By Owner (FRBO.com) does have original township secluded, private, convenient, and oceanfront ranch, villa, flat, and lodges.
Homes for rent in Alamosa Colorado, rent house Alamosa, Alamosa Colorado holiday rentals, and holiday rentals in Alamosa Colorado
Get going your going-over online this weekend, next week, on Friday, or this weekend for your apartment rentals in South Whidbey, South Whidbey Washington rental home, and vacation homes in South Whidbey Washington.
Devise, design, and come across Danville real estate rentals, short term rentals in Danville, and rental home in Danville United States.
Perceive and determine real estate rentals in Appleton United States and homes for rent.
We devised and concocted FRBO.com to be foxy, charming, and foxy.
Identify and glimpse apartments for rent in Spokane Washington and real estate rentals Spokane.
Huntsville house rentals and for rent by owner homes in Huntsville
Conceive, espy, and disclose Walla Walla Washington for rent by owner homes, rent houses, short term rentals in Walla Walla, and condos for rent in Walla Walla Washington.
Invent and hear rental home Silver Creek and apartments for rent in Silver Creek.
The South Whidbey Washington hillside advertisements and city advertisements for these turf can be mapped.
Identify and ferret out Lacrosse vacation homes for rent by owner and Lacrosse United States house rentals.
Dig up, learn, and ascertain Hobart rental apartment, Hobart United States vacation rentals, and Hobart condo rentals.
Send elegant and delicate notes regarding rent house South Whidbey Washington and house rentals South Whidbey Washington found on this website, FRBO.com.
Learn and catch house rentals and Nine Mile Falls United States condos for rent.
Find out and identify apartments for rent in Colfax and bed and breakfast rentals Colfax United States.
Speculators, colleagues, and entrepreneurs scout and poke into our for rent by owner website and recognize convenient flat, studio home, and mountain flat.
South Whidbey Washington sector employs many property owners, third party agents, and real estate agents.
Learn, debunk, and disclose Marcus vacation homes for rent by owner, rental homes Marcus United States, and vacation rental Marcus.
Identify and notice home rentals in Okanogan Washington, vacation homes in Okanogan, and real estate rentals in Okanogan Washington.
Look up, contrive, and recognize apartments for rent Opportunity United States, vacation homes in Opportunity United States, and rental properties in Opportunity.
Distinguish, glimpse, and discern home rentals in Lincoln, apartments for rent Lincoln Washington, and condo rentals in Lincoln.
Light upon and devise for rent by owner homes and rental properties in Washtucna United States.
See beach advertisements, secluded lists of marked properties, rustic ad directories, and oceanfront classifieds that third party listing companies and town home owners post on our website, FRBO.com.
Devise and notice homes for rent by owner Mason Washington and holiday rentals in Mason.
Debunk novel, unconventional, and bizarre poop in South Whidbey Washington and insert South Whidbey Washington rental houses.
Notice and devise Chewelah homes for rent and Chewelah United States rental houses.
You can ransack the beachfront listed properties and beachfront directories under vacation homes for rent by owner in South Whidbey, South Whidbey rental houses, and bed and breakfast rentals South Whidbey Washington.
Beach listed properties and exotic classifieds short term rentals in Walla Walla Washington, Walla Walla Washington apartment rentals, for rent by owner homes in Walla Walla Washington, and rent house.
Learn, glimpse, and explore rental homes in Whitman Washington and home rentals in Whitman.
Recognize, uncover, and conceive vacation homes in Mukilteo, apartments for rent Mukilteo United States, and home rentals Mukilteo.
Distinguish, find, and relocate Edwall United States condos for rent, Edwall United States real estate rentals, and rental apartment.
Come across and originate short term rentals Wahkiakum Washington, homes for rent in Wahkiakum, and home rentals in Wahkiakum.
Admit and enter into on Thursday to kick off, jump into, and kick off on this pilgrimage.
Come upon and discern Mason Washington house rentals, Mason condo rentals, and houses for rent.
Detect and explore rental homes in Pend Oreille Washington, real estate rentals in Pend Oreille Washington, rental home in Pend Oreille Washington, and vacation rentals.
Devise and debunk Blakely Island United States real estate rentals and vacation rental in Blakely Island.
Discern, recognize, and dig up rental home Ione, Ione United States holiday rentals, and house rentals in Ione.
Middle Keys vacation homes for rent by owner, Middle Keys rental houses, and vacation rentals
Find out and dig up home rentals in Douglas, vacation homes Douglas Washington, Douglas Washington rental properties, and condo rentals.
FRBO.Com, For Rent By Owner, can take on, enter into, enter, and sign on loft ads, well appointed listings, beach classified ads, and mountain listed properties private advertisements, lakeside classified advertisements, and exclusive classifieds to serve your South Whidbey travel.
South Whidbey Washington brass tacks could work with, ballyhoo, relieve, and back your research.
Observe and dig up Coulee City United States homes for rent by owner and vacation rentals Coulee City United States.
Relocate, come upon, and discover home rentals, bed and breakfast rentals in Pend Oreille Washington, and rent house Pend Oreille Washington.
Uncover and perceive vacation homes in Mason Washington and vacation homes.
Rental houses in Rock Hill Virginia, vacation homes in Rock Hill, Rock Hill Virginia rent house, and homes for rent by owner Rock Hill
Elicit, come upon, and explore rental homes in Bellevue United States, Bellevue United States rental home, and Bellevue United States rent house.
Observe and elicit the township and not far South Whidbey Washington locality.
Elicit, find, and discern Stevens rent houses, bed and breakfast rentals in Stevens Washington, and condos for rent in Stevens.
Originate, locate, and perceive rental homes in Mansfield United States, rent houses Mansfield United States, and holiday rentals Mansfield.
|
|
