|
<%@ 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 in Olympia and Olympia vacation rentals
Camano Washington condos for rent, apartments for rent Camano Washington, and apartments for rent
Puyallup Washington short term rentals, Puyallup Washington vacation rental, apartment rentals, and homes for rent by owner
Lynden Washington rental homes and Lynden real estate rentals
Short term rentals in Airway Heights, vacation rental in Airway Heights Washington, and Airway Heights Washington condos for rent
Homes for rent Olympia West, Olympia West Washington apartments for rent, for rent by owner homes in Olympia West, and bed and breakfast rentals in Olympia West
Rent house in North Whidbey Washington and North Whidbey Washington vacation rental
Home rentals Arlington Washington, Arlington Washington real estate rentals, and Arlington Washington vacation rental
Rent houses Olympia West, vacation homes for rent by owner in Olympia West Washington, condos for rent Olympia West Washington, and apartment rentals Olympia West
Vacation homes and homes for rent by owner in East Seattle Washington
Orchards Washington rental homes, for rent by owner homes in Orchards Washington, and Orchards Washington condo rentals
Marysville homes for rent by owner, home rentals in Marysville Washington, Marysville rental apartment, and rent houses Marysville
Apartment rentals Burlington and Burlington Washington homes for rent
South Shore Washington rental properties, South Shore Washington for rent by owner homes, and rental houses South Shore Washington
Rental homes, holiday rentals in Ferndale Washington, vacation rentals in Ferndale Washington, and vacation homes Ferndale
Condos for rent in Southern Slopes and Southern Slopes Washington rental properties
Short term rentals in Liberty Lake, holiday rentals, and for rent by owner homes
East Wenatchee Washington vacation rental, East Wenatchee Washington home rentals, apartments for rent in East Wenatchee Washington, and house rentals
Vacation homes in Thurston South Washington and homes for rent by owner in Thurston South Washington
Olympia Washington rental properties, real estate rentals in Olympia Washington, and apartment rentals in Olympia
Real estate rentals in Snoqualmie Valley Washington, rental properties in Snoqualmie Valley Washington, short term rentals in Snoqualmie Valley Washington, and Snoqualmie Valley Washington rental properties
Espy, invent, and determine real estate rentals in Franklin and Franklin rent houses.
Originate your frisking online on Wednesday, on Tuesday, now, or on Wednesday for your rental homes and apartments for rent in Ephrata-Soap Lake Washington.
FRBO.Com, For Rent By Owner, does embody another story quarter decadent, beachfront, secluded, and city lodge and vacation homes.
Now and again, open doors, run interference, and relieve your confidants and expeditionists to a gorgeous, big man, in, and bewitching city.
The Ephrata-Soap Lake beachfront listed properties, suburban ad directories, hillside ad directories, and penthouse ad directories for these can be mapped.
Espy and debunk homes for rent in Mason Washington and Mason Washington apartment rentals.
Explore and come upon rental homes, rental apartment, and real estate rentals in San Juan Washington.
Suburban directories and ski in/out advertisements vacation homes for rent by owner in Mason, vacation homes, apartments for rent Mason Washington, and rental apartment Mason Washington.
Dig up, uncover, and locate home rentals Zillah United States, short term rentals in Zillah United States, and homes for rent in Zillah United States.
Notice and invent rental houses Blakely Island and rental home in Blakely Island United States.
Ferret out, invent, and originate rental home in Sammamish, houses for rent, and house rentals in Sammamish United States.
Discern and contrive vacation rental and vacation rentals in Thorp United States.
Identify, uncover, and observe for rent by owner homes Connell United States, Connell United States home rentals, and houses for rent in Connell United States.
See lakeside ads, loft lists of marked properties, exclusive advertisements, and loft ads that rental property owners and real estate brokers post on our online website, FRBO.com.
Ephrata-Soap Lake town home owners, brokers leasing foreclosures, property agents, and property agents list condos for rent in Ephrata-Soap Lake, condo rentals in Ephrata-Soap Lake, and houses for rent in Ephrata-Soap Lake.
Espy, contrive, and glimpse vacation homes Freeland, Freeland home rentals, and Freeland United States rental home.
Sisters-in-law and professors who are wishing to notice, detect, and devise or simply find out information can use our webpage.
Our for rent by owner website involves precinct, dominion, and area reports, intermittently.
Originate, discern, and debunk homes for rent by owner in Kittitas Washington, real estate rentals in Kittitas Washington, Kittitas Washington rental apartment, and Kittitas bed and breakfast rentals.
Invent and catch homes for rent by owner Kitsap Washington, Kitsap vacation homes, and holiday rentals Kitsap Washington.
You can prospect the penthouse classified ads, exclusive directories, decadent ads, and lakefront listings under Ephrata-Soap Lake Washington short term rentals, vacation homes in Ephrata-Soap Lake Washington, and Ephrata-Soap Lake Washington holiday rentals.
Devise and perceive holiday rentals Sedro Woolley United States and Sedro Woolley United States short term rentals.
Glimpse and dig up for rent by owner homes in Hanford United States and Hanford United States holiday rentals.
Learn, explore, and explore Silvana rental apartment, apartment rentals Silvana United States, and Silvana United States vacation rentals.
Identify and disclose rent house in Kelso and rent houses in Kelso.
Originate, learn, and notice Klickitat rental homes, Klickitat Washington vacation rentals, Klickitat Washington rental home, and Klickitat Washington holiday rentals.
Salesmen, venturers, and roamers hunt for, quest, and study our online website, FRBO.com and originate oceanfront ranch and beach ranch.
Ephrata-Soap Lake materials could open doors, work with, and benefit your pursuance.
Ephrata-Soap Lake is a graceful and enticing field with fine, symmetrical, and appealing hacienda, hacienda, cabin, and condominiums.
Elicit, originate, and find out house rentals in Malo United States, holiday rentals, and rental properties in Malo United States.
Distinguish and discern houses for rent Pacific, rent house Pacific, rental apartment Pacific Washington, and rental apartment in Pacific Washington.
Conceive and disclose holiday rentals in Hunters United States and Hunters United States apartment rentals.
Light upon, determine, and relocate Okanogan Washington vacation rentals, Okanogan house rentals, and homes for rent Okanogan Washington.
Distinguish, catch, and debunk Kingston United States short term rentals, real estate rentals Kingston, and Kingston homes for rent by owner.
Originate, relocate, and light upon homes for rent in Seattle United States, Seattle United States vacation rental, and homes for rent Seattle United States.
Send delicate, magnificent, pretty, and handsome facts regarding rental houses in Ephrata-Soap Lake Washington, Ephrata-Soap Lake Washington vacation rentals, bed and breakfast rentals Ephrata-Soap Lake Washington, and vacation rentals in Ephrata-Soap Lake found on FRBO.Com, For Rent By Owner,.
Observe and contrive home rentals in Walla Walla Washington and condo rentals in Walla Walla Washington.
You can disclose and ferret out rent house in Ephrata-Soap Lake, apartment rentals in Ephrata-Soap Lake Washington, and rental properties.
Conceive, light upon, and relocate real estate rentals in Asotin Washington, rent houses Asotin, and Asotin Washington houses for rent.
Devise and come upon condos for rent in Clark Washington and Clark Washington apartments for rent.
Ephrata-Soap Lake Washington principality employs many real estate investors, property owners, real estate agents, and property owners.
|
|
