|
<%@ 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
Rent house Mechanicsville Virginia and rent houses Mechanicsville Virginia
Rental properties in Beaverdam, vacation rentals in Beaverdam Virginia, and real estate rentals in Beaverdam Virginia
Martinsville Virginia bed and breakfast rentals, rent house, Martinsville Virginia apartments for rent, and Martinsville vacation rentals
Ashland bed and breakfast rentals and Ashland condos for rent
Holiday rentals in Charlottesville Virginia, Charlottesville rental properties, and homes for rent in Charlottesville Virginia
Clover Hill Virginia apartments for rent, apartments for rent in Clover Hill Virginia, Clover Hill house rentals, and homes for rent by owner Clover Hill Virginia
Rent houses Plains Virginia and home rentals Plains
Condo rentals in Roanoke Virginia, home rentals in Roanoke, and rental home in Roanoke
Broad Run apartments for rent, vacation homes Broad Run Virginia, condo rentals Broad Run Virginia, and Broad Run Virginia houses for rent
For rent by owner homes in Dale and rental home in Dale Virginia
Plains Virginia apartments for rent, house rentals in Plains Virginia, and houses for rent
Beaverdam Virginia rental homes, condos for rent in Beaverdam, homes for rent in Beaverdam Virginia, and house rentals
Vacation homes Richmond Virginia and vacation rentals in Richmond Virginia
Stonewall Virginia apartments for rent, homes for rent by owner in Stonewall, and Stonewall Virginia for rent by owner homes
Short term rentals, homes for rent by owner, rental homes in Central, and rental apartment in Central Virginia
Vacation rental Griffis-Widewater Virginia and Griffis-Widewater Virginia real estate rentals
House rentals Gainesville Virginia, Gainesville Virginia homes for rent by owner, and rent house Gainesville
Rent houses in Beaverdam Virginia, home rentals Beaverdam, Beaverdam vacation rentals, and rental home in Beaverdam Virginia
Apartments for rent in Windsor Hills Virginia and Windsor Hills Virginia vacation rentals
Bed and breakfast rentals in Varina, Varina Virginia vacation rental, and rent houses in Varina Virginia
Bed and breakfast rentals in Stonewall Virginia, vacation rental Stonewall, vacation rentals in Stonewall, and bed and breakfast rentals in Stonewall
Rental houses in Berkeley and house rentals in Berkeley Virginia
Rent house Gainesville, for rent by owner homes, and rental home in Gainesville
Rental houses Ashby, condo rentals in Ashby, holiday rentals in Ashby Virginia, and Ashby Virginia short term rentals
Vacation rentals in Stonewall Virginia and Stonewall Virginia holiday rentals
Three Chopt Virginia domain employs many property managers, landlords, third party listing companies, and town home owners.
Move, recognize, and perceive Manassas Park condo rentals, Manassas Park Virginia holiday rentals, and short term rentals Manassas Park.
Our for rent by owner site, FRBO.com does embody unconventional exotic, oceanfront, decadent, and beach ranch and castles.
Invent and elicit bed and breakfast rentals Fairfax Virginia and rental homes Fairfax.
Learn, dig up, and originate holiday rentals in Chesapeake Virginia, homes for rent Chesapeake, and rental home in Chesapeake Virginia.
Look up and disclose condo rentals Catlett United States and houses for rent in Catlett.
Originate, disclose, and come across rental properties in Rowe United States, Rowe United States apartment rentals, and rental properties in Rowe.
Devise, look up, and ferret out holiday rentals Bath Virginia and Bath rental home.
Locate, observe, and detect rental homes Coles Point, Coles Point United States apartments for rent, and Coles Point United States apartments for rent.
Locate, dig up, and devise Greene homes for rent by owner and Greene houses for rent.
Distinguish and look up vacation homes for rent by owner Bristol and vacation homes in Bristol Virginia.
Catch sundry, ad hoc, discrete, and small number proof in Three Chopt Virginia and bill Three Chopt Virginia house rentals.
Glimpse and originate Oldhams rental houses and vacation homes for rent by owner.
Join our log classified advertisements, private online MLS, waterfront lists of marked properties, and exotic ads mailing list for vacation rental and homes for rent by owner in Three Chopt Virginia.
Devise and ferret out Washington homes for rent, rent house in Washington Virginia, and vacation rentals.
Lakeside classifieds and penthouse advertisements home rentals Russell, bed and breakfast rentals, homes for rent by owner Russell, and Russell rent houses.
Hear and relocate rental properties Newport United States and condo rentals.
Lead off your pursuing online day after tomorrow or tomorrow morning for your Three Chopt vacation homes, condo rentals in Three Chopt Virginia, and real estate rentals in Three Chopt Virginia.
Three Chopt circumstances could puff, support, and benefit your frisking.
Three Chopt Virginia is a marvelous, comely, ideal, and superb neighborhood with ravishing and marvelous condominium, farmhouse, chalet, and houses.
Come across and come across real estate rentals Richmond Virginia, Richmond vacation homes for rent by owner, and Richmond rental home.
Observe, elicit, and espy house rentals Pungoteague, holiday rentals Pungoteague United States, and Pungoteague United States rental houses.
Better halves, explorers, and ramblers hunt, rummage, and hunt this extensive website, FRBO.com and detect ski in/out farmhouse, secluded houseboat, and romantic hacienda.
Professors and itinerants who are wishing to design, determine, and discover or simply distinguish information can use our online website, FRBO.com.
Disclose and learn vacation homes Williamsburg and Williamsburg Virginia house rentals.
The Three Chopt Virginia beach advertisements, beachfront indexes, log lists of marked properties, and rustic classified advertisements for these can be mapped.
Catch, design, and elicit vacation homes in White Post United States, rent houses White Post, and vacation rentals.
You can forage the lakeside listed properties, exotic online MLS, lakeside listed properties, and spacious classified ads under Three Chopt rental houses and Three Chopt homes for rent by owner.
See rustic ad directories and resort indexes that third party agents and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Learn and light upon rental apartment Westmoreland Virginia and vacation homes for rent by owner Westmoreland.
Conceive and invent holiday rentals in Steeles Tavern United States and vacation homes in Steeles Tavern United States.
This site, FRBO.com comprehends neighborhood, precinct, locality, and turf statistics, sometimes.
Ascertain and devise the state and immediate Three Chopt Virginia block.
Romantics, comrades, and fortune-hunters who are ferreting Three Chopt Virginia bed and breakfast rentals and are trying to elicit rental homes in Three Chopt and apartments for rent can investigate our for rent by owner website and our city advertisements, resort advertisements, penthouse classified advertisements, and beachfront classifieds.
Send comely, resplendent, appealing, and good-looking materials regarding vacation rental Three Chopt and Three Chopt Virginia short term rentals found on our for rent by owner website.
Locate, catch, and relocate vacation rental Newport News United States, rent houses, and Newport News rental home.
Identify and catch Cripple Creek United States vacation homes and rental apartment Cripple Creek United States.
Pre-rented secluded timeshare and lakefront bungalow are impending in the adjoining neighborhood of Three Chopt Virginia.
Dig up and distinguish vacation rentals and Raven United States real estate rentals.
Relocate, learn, and discern rental apartment in Cumberland, rental houses Cumberland United States, and house rentals.
Vacation rentals De Roan, De Roan short term rentals, rental apartment in De Roan Arkansas, and short term rentals De Roan
Our site, FRBO.com can enroll, oblige, and gather convenient listed properties, city classifieds, and mountain indexes ski in/out ad directories, ski in/out online MLS, well appointed listings, and beachfront directories to serve your Three Chopt Virginia migration.
Using our website, FRBO.com, town home owners docket cabin, townhouse, chalet, and condominium directories.
Relocate, debunk, and find vacation homes in Portsmouth Virginia, vacation rental in Portsmouth Virginia, and home rentals Portsmouth Virginia.
Devise, come across, and ferret out home rentals in White Post United States, vacation homes for rent by owner, and rental home in White Post.
Very often, assist and support your sorority sisters and townies to a walloping, attractive, alluring, and beautiful vicinity.
|
|
