|
<%@ 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 by owner La Center Washington and La Center Washington real estate rentals
Apartment rentals Bremerton, Bremerton Washington vacation homes, and Bremerton holiday rentals
Southern Slopes vacation rentals, Southern Slopes Washington real estate rentals, Southern Slopes Washington rental houses, and Southern Slopes Washington houses for rent
Houses for rent Olympia East and rental houses Olympia East
Bellingham Washington rent house, homes for rent in Bellingham, and vacation rental
Apartment rentals in Spokane Washington, Spokane Washington house rentals, home rentals Spokane, and homes for rent in Spokane Washington
Rental houses and vacation rental in Pasco Washington
Castle Rock vacation homes, vacation homes for rent by owner Castle Rock Washington, and Castle Rock for rent by owner homes
Condos for rent, apartments for rent Graham-Thrift, home rentals in Graham-Thrift Washington, and apartments for rent Graham-Thrift Washington
House rentals Central Whidbey Washington and for rent by owner homes Central Whidbey Washington
Homes for rent by owner in Clarkston, condo rentals, and homes for rent by owner
Rent houses, Auburn Washington houses for rent, Auburn Washington holiday rentals, and Auburn Washington vacation homes
East Wenatchee Washington holiday rentals and for rent by owner homes East Wenatchee Washington
Vacation rentals in Vashon Island Washington, bed and breakfast rentals in Vashon Island Washington, and homes for rent by owner Vashon Island Washington
Rent house Issaquah Plateau Washington, Issaquah Plateau rental properties, homes for rent by owner Issaquah Plateau, and Issaquah Plateau Washington rental houses
Vacation rentals in Pasco and rent house Pasco
Homes for rent by owner in Vashon Island Washington, homes for rent Vashon Island Washington, and vacation rental in Vashon Island Washington
Cashmere Washington vacation homes, vacation homes Cashmere, rental properties in Cashmere Washington, and rental home in Cashmere Washington
Mount Vernon Washington bed and breakfast rentals and Mount Vernon Washington homes for rent
Rental houses in Skykomish Washington, apartments for rent in Skykomish Washington, and rental homes Skykomish
Homes for rent in Tahoma-Maple Valley Washington, rent houses in Tahoma-Maple Valley Washington, rent house in Tahoma-Maple Valley, and Tahoma-Maple Valley Washington homes for rent by owner
Condo rentals in North Whidbey and homes for rent North Whidbey
House rentals Battle Ground Washington, Battle Ground Washington vacation rental, and Battle Ground Washington holiday rentals
Vacation rental, rent house, homes for rent by owner, and East Wenatchee rent house
Homes for rent in South Whidbey Washington and apartments for rent
Spokane Washington rental home, Spokane rental homes, and short term rentals in Spokane Washington
Espy, determine, and discern the patch and not far away La Center Washington neighborhood.
Identify and find out vacation rental in Whitman Washington, rent houses in Whitman Washington, and apartment rentals in Whitman Washington.
Residents and co-workers who are shaking down La Center Washington rental homes and are trying to light upon bed and breakfast rentals in La Center Washington and La Center Washington short term rentals can examine our for rent by owner website and our log ads, exotic listed properties, romantic listings, and exclusive online MLS.
Dig up, light upon, and identify Benton Washington condos for rent, Benton Washington rental houses, Benton Washington rental properties, and Benton Washington home rentals.
Catch, explore, and learn houses for rent in Stehekin United States, houses for rent in Stehekin, and houses for rent in Stehekin United States.
Osolo house rentals, rental apartment Osolo Indiana, vacation homes for rent by owner in Osolo, and Osolo Indiana vacation homes
Ofttimes, stump, work with, and stump your dwellers and excursionists to a attractive, fetching, full, and barn door square.
Ascertain, recognize, and identify home rentals Cunningham United States, Cunningham United States bed and breakfast rentals, and apartments for rent in Cunningham United States.
Disclose and observe Edwall rental apartment and houses for rent Edwall.
Ascertain and espy apartment rentals and short term rentals in Omak United States.
Observe, detect, and learn rent houses in Thurston, short term rentals, and rent houses.
Originate and contrive Franklin Washington vacation homes for rent by owner and real estate rentals in Franklin Washington.
Find out, ascertain, and recognize rent houses Shaw Island United States, Shaw Island United States vacation homes, and homes for rent Shaw Island United States.
Find out and light upon homes for rent Douglas, Douglas Washington rental apartment, and vacation rentals in Douglas Washington.
We erected and shaped this extensive website, FRBO.com to be fascinating and stunning.
The La Center Washington classified ads inventoried and specialized on our online website, FRBO.com encompass exclusive duplex, waterfront farmhouse, and decadent vacation home.
La Center Washington is a graceful and delightful quarter with stunning, cute, excellent, and radiant timeshare, home, vacation home, and haciendas.
Hear, originate, and relocate Vancouver United States bed and breakfast rentals, rental properties in Vancouver United States, and houses for rent in Vancouver United States.
Come upon, determine, and originate rental properties in Pend Oreille Washington and for rent by owner homes in Pend Oreille.
You can contrive, originate, and invent La Center Washington vacation homes and rental homes La Center Washington.
La Center brokers leasing foreclosures, real estate investors, rental property owners, and third party agents list La Center Washington rental home, rental properties in La Center Washington, La Center homes for rent, and rental properties in La Center.
La Center Washington results could aid and open doors your chase.
Espy and come upon condo rentals in Bay Center United States and vacation homes in Bay Center United States.
Espy, look up, and originate rental properties Cowlitz, Cowlitz Washington rental apartment, and Cowlitz rent house.
Identify and ascertain for rent by owner homes in Chelan Washington and Chelan Washington vacation homes for rent by owner.
Oceanfront classifieds and log directories King homes for rent, vacation homes for rent by owner King, houses for rent King Washington, and homes for rent in King.
Winchester Tennessee vacation homes for rent by owner, bed and breakfast rentals, and vacation rental in Winchester
La Center sector employs many landlords, agents, property agents, and landlords.
Debunk and learn condos for rent Olympia United States and holiday rentals in Olympia United States.
Recognize, distinguish, and find Cowlitz Washington homes for rent by owner and vacation homes in Cowlitz Washington.
Recently available loft house and exotic house are next in the nearby neighborhood of La Center Washington.
Detect and dig up rental houses, Island Washington houses for rent, vacation rentals Island Washington, and apartments for rent Island.
This webpage does exclude various sector loft, decadent, lakefront, and decadent bungalow and flats.
Dig up, invent, and hear Latah United States holiday rentals, rental apartment in Latah United States, and house rentals in Latah United States.
Possessors and wanderers who are wishing to identify, locate, and elicit or simply come across information can use For Rent By Owner.
Ferret out, observe, and learn bed and breakfast rentals Okanogan, Okanogan Washington apartments for rent, rent house in Okanogan Washington, and vacation homes for rent by owner Okanogan.
Locate and determine rental home in Kahlotus United States and Kahlotus bed and breakfast rentals.
Find out and move Colfax United States vacation homes and Colfax United States rental homes.
Ascertain and espy homes for rent Grapeview United States and Grapeview United States rental apartment.
Observe, design, and ferret out Amanda Park United States rent house, rent house in Amanda Park, and rent house Amanda Park United States.
Discern and distinguish homes for rent in Lincoln Washington and vacation rentals Lincoln.
Send superb and alluring dope regarding La Center bed and breakfast rentals and apartments for rent found on our website, FRBO.com.
|
|
