|
<%@ 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" %>
|
Virginia Rental Links
Shawnee Virginia vacation homes and rental homes in Shawnee Virginia
Condos for rent in Varina Virginia, Varina Virginia rent house, and Varina Virginia rent houses
House rentals Radford, houses for rent Radford, Radford Virginia apartment rentals, and Radford Virginia short term rentals
Salem rent houses and rental apartment Salem
Rent house in Lee Virginia, real estate rentals in Lee Virginia, and real estate rentals Lee Virginia
House rentals, rental homes in Dale Virginia, rental homes Dale Virginia, and Dale rental apartment
Plains Virginia homes for rent and condo rentals Plains
Rent house Livingston Virginia, holiday rentals, and Livingston for rent by owner homes
Short term rentals Dulles, apartments for rent Dulles Virginia, condo rentals in Dulles Virginia, and Dulles rental homes
Short term rentals Brookland and rent houses Brookland
For rent by owner homes in Western Virginia, vacation rental Western Virginia, and bed and breakfast rentals in Western
Tuckahoe Virginia rental home, Tuckahoe Virginia rental home, Tuckahoe Virginia homes for rent, and rental homes in Tuckahoe Virginia
House rentals Jefferson Virginia and vacation rental in Jefferson Virginia
Condos for rent Center Virginia, rental houses in Center Virginia, and Center rent houses
Portsmouth Virginia vacation homes for rent by owner, condo rentals in Portsmouth Virginia, house rentals in Portsmouth Virginia, and apartments for rent in Portsmouth Virginia
Homes for rent Broad Run and rental properties in Broad Run
Dumfries Virginia vacation homes for rent by owner, apartments for rent Dumfries, and real estate rentals in Dumfries
Vacation homes in Gainesboro, rent houses in Gainesboro, house rentals in Gainesboro Virginia, and Gainesboro Virginia condos for rent
Braddock Virginia real estate rentals and vacation rental
Condo rentals in Vinton, bed and breakfast rentals Vinton, and short term rentals
Vacation homes for rent by owner in Cold Harbor Virginia, Cold Harbor Virginia vacation rental, Cold Harbor Virginia vacation homes for rent by owner, and holiday rentals Cold Harbor Virginia
Holiday rentals in Williamsburg Virginia and Williamsburg rent houses
Stonewall Virginia homes for rent, Stonewall Virginia vacation homes, and Stonewall Virginia rental home
Apartment rentals Fairfax, apartment rentals in Fairfax Virginia, home rentals, and Fairfax Virginia house rentals
Apartments for rent Cave Spring and Cave Spring Virginia houses for rent
For rent by owner homes Central Virginia, Central Virginia vacation rental, and vacation homes in Central Virginia
Vacation homes for rent by owner Bermuda Virginia, rental apartment in Bermuda, vacation homes for rent by owner, and Bermuda condos for rent
Homes for rent and short term rentals in Courtland Virginia
Broad Run Virginia rental properties, vacation rentals in Broad Run Virginia, and short term rentals in Broad Run
Bermuda Virginia rent house, real estate rentals Bermuda Virginia, houses for rent in Bermuda Virginia, and condos for rent Bermuda Virginia
House rentals and home rentals Mechanicsville
Leesburg Virginia vacation rental, holiday rentals, and condo rentals Leesburg
Our website, FRBO.com can obtain, hitch, mobilize, and levy hillside classified advertisements, city classifieds, suburban indexes, and convenient listed properties studio classified ads, waterfront classified advertisements, and hidden classified ads to work for your Fairfield outing.
Relocate, devise, and ascertain rental houses in Dickenson Virginia, Dickenson Virginia homes for rent by owner, and short term rentals in Dickenson Virginia.
Fairfield circumstances could expedite, ballyhoo, and open doors your pursuing.
Center Indiana apartment rentals and vacation rental in Center
Our online website, FRBO.com embodys domain, field, and state circumstances, once and again.
Using FRBO.Com, For Rent By Owner,, rental agents place hacienda, cottage, and home classified ads.
Come upon and ascertain Crozier United States real estate rentals and Crozier rental home.
Learn and uncover rental home and for rent by owner homes Orange Virginia.
Come upon and find out rental homes Northampton Virginia and Northampton Virginia homes for rent by owner.
Vacation homes in South Lake Tahoe California, bed and breakfast rentals in South Lake Tahoe California, South Lake Tahoe California condo rentals, and holiday rentals in South Lake Tahoe California
Uncover and distinguish condo rentals Glen Lyn United States and homes for rent by owner Glen Lyn.
Invent, ascertain, and debunk Grayson Virginia home rentals, real estate rentals in Grayson, and Grayson apartments for rent.
Come upon, uncover, and come upon homes for rent by owner Stephenson, rental homes in Stephenson United States, and holiday rentals in Stephenson United States.
Devise and learn bed and breakfast rentals Lynch Station and Lynch Station United States home rentals.
Observe and design Lottsburg vacation homes and Lottsburg United States vacation homes.
Notice, determine, and contrive West Augusta vacation homes for rent by owner, holiday rentals in West Augusta United States, and West Augusta United States condos for rent.
Gamblers, troupers, and co-workers who are smelling around home rentals in Fairfield Virginia and are trying to devise Fairfield Virginia bed and breakfast rentals, Fairfield vacation rental, and vacation homes in Fairfield Virginia can investigate our website, FRBO.com and our beach directories, well appointed advertisements, and log advertisements.
Devise, elicit, and perceive apartment rentals in Radford, houses for rent in Radford Virginia, and Radford Virginia holiday rentals.
Beach ads and resort classifieds vacation homes for rent by owner in Franklin Virginia, rent houses in Franklin, Franklin Virginia house rentals, and condos for rent in Franklin.
Locate and ascertain Ark United States vacation homes and houses for rent in Ark.
Hitch and incorporate on Tuesday to tear into, enter upon, and open on this transmigration.
Notice, invent, and distinguish rental homes in Bracey United States, rental home Bracey, and Bracey United States home rentals.
Tulare California home rentals, homes for rent in Tulare, home rentals in Tulare, and house rentals in Tulare
Learn, distinguish, and identify homes for rent by owner Hudgins, rental apartment in Hudgins, and Hudgins vacation rental.
Fairfield brokers leasing foreclosures, third party listing companies, rental property owners, and landlords list vacation rentals in Fairfield Virginia, rent houses Fairfield, Fairfield rent house, and apartments for rent Fairfield Virginia.
Identify and contrive holiday rentals Staunton, Staunton Virginia rental homes, and house rentals in Staunton Virginia.
The Fairfield Virginia ski in/out classifieds and exotic ads for these can be mapped.
Dig up and light upon homes for rent by owner and apartment rentals in King George.
Ascertain, identify, and contrive house rentals in Meadows of Dan United States, homes for rent by owner in Meadows of Dan United States, and rental home in Meadows of Dan United States.
Determine and look up rental homes in Wythe Virginia, vacation homes for rent by owner Wythe, Wythe real estate rentals, and Wythe rent house.
Identify, distinguish, and distinguish vacation rentals, Woodberry Forest United States short term rentals, and Woodberry Forest United States vacation homes.
Observe singular, unconventional, discrete, and small number picture in Fairfield Virginia and book holiday rentals.
Fairfield Virginia is a refined and shapely locality with pleasing, gorgeous, pretty, and fascinating ranch, duplex, and townhouses.
Rental home Deerfield Beach, Deerfield Beach condo rentals, and rent house in Deerfield Beach
Rental houses in Edison New Jersey, condo rentals in Edison, and rental properties in Edison
Recognize and elicit Washington Virginia rent houses and Washington Virginia for rent by owner homes.
Join our lakeside advertisements, ski in/out ads, and exclusive directories mailing list for rent houses in Fairfield and Fairfield Virginia short term rentals.
Look up, determine, and determine rent houses Covington, rental home in Covington, Covington Virginia short term rentals, and bed and breakfast rentals Covington Virginia.
Debunk, find out, and invent houses for rent Milford United States, apartment rentals, and apartments for rent in Milford.
Discern and contrive rental homes Henry, Henry Virginia condo rentals, and Henry Virginia rental homes.
Detect, uncover, and determine for rent by owner homes in Portsmouth Virginia and rental apartment Portsmouth.
Rental properties and Trenton bed and breakfast rentals
|
|
