|
<%@ 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
Poquoson Virginia rent houses and Poquoson Virginia rent houses
Rock Hill rent house, apartment rentals Rock Hill Virginia, and Rock Hill Virginia vacation homes
South River Virginia rental properties, vacation homes for rent by owner in South River Virginia, short term rentals, and South River condos for rent
Bristol houses for rent and Bristol Virginia homes for rent by owner
Portsmouth Virginia apartments for rent, Portsmouth Virginia rental apartment, and short term rentals in Portsmouth
Rental homes Rivanna, holiday rentals in Rivanna Virginia, homes for rent by owner in Rivanna, and rent house Rivanna
Powhatan Virginia real estate rentals and condo rentals in Powhatan Virginia
Vacation rental in George Washington Virginia, vacation homes George Washington, and rental apartment in George Washington Virginia
Shawnee Virginia apartments for rent, apartments for rent in Shawnee Virginia, rental homes in Shawnee, and short term rentals in Shawnee
Vacation homes for rent by owner and vacation rentals Stonewall Virginia
Short term rentals in Scott Virginia, condo rentals Scott, and Scott Virginia short term rentals
Cave Spring apartments for rent, vacation rental in Cave Spring Virginia, Cave Spring Virginia vacation rentals, and short term rentals in Cave Spring Virginia
For rent by owner homes in Rivanna Virginia and Rivanna Virginia house rentals
Rent houses in Falmouth Virginia, apartment rentals in Falmouth, and rental properties Falmouth Virginia
Vacation rentals in Virginia Beach Virginia, rental home, condos for rent in Virginia Beach Virginia, and condo rentals in Virginia Beach Virginia
Vacation rentals Rio and Rio real estate rentals
Rent house in Catawba, condo rentals Catawba, and Catawba holiday rentals
Rivanna Virginia bed and breakfast rentals, holiday rentals in Rivanna Virginia, home rentals, and house rentals in Rivanna Virginia
Bed and breakfast rentals in Hampton and vacation homes
Hartwood vacation rentals, vacation rental in Hartwood Virginia, and apartment rentals in Hartwood Virginia
Dulles Virginia vacation rentals, Dulles home rentals, rent house Dulles, and homes for rent in Dulles
Rental home Hunter Mill and condo rentals in Hunter Mill Virginia
Leesburg real estate rentals, holiday rentals, and rental houses in Leesburg
Rio Virginia vacation homes, for rent by owner homes in Rio, homes for rent by owner, and for rent by owner homes in Rio Virginia
Rental properties in Mason and Mason homes for rent
Lynchburg Virginia homes for rent, rental homes Lynchburg, and vacation rentals Lynchburg
House rentals Hampton Virginia, Hampton Virginia for rent by owner homes, rental apartment Hampton, and rental properties Hampton
Rent house and condos for rent Vinton Virginia
Powhatan Virginia rental home, vacation rental Powhatan Virginia, and vacation homes for rent by owner
Rental properties, Braddock Virginia holiday rentals, Braddock Virginia apartments for rent, and home rentals Braddock
Elicit and recognize Troutville vacation rentals and rent house in Troutville.
Disclose and discern vacation homes for rent by owner in Fairfax Virginia, rental apartment Fairfax Virginia, and rental apartment in Fairfax Virginia.
Find, dig up, and ascertain Hadensville United States homes for rent by owner, rental home in Hadensville United States, and houses for rent Hadensville United States.
See suburban classifieds, suburban ads, beach ads, and beachfront classified ads that property brokers and property owners post on FRBO.Com, For Rent By Owner,.
Discern and locate condo rentals in Lunenburg Virginia and Lunenburg rental apartment.
Explore and discover Wythe Virginia vacation rentals and for rent by owner homes Wythe.
Explore, ferret out, and notice apartment rentals, rental homes in Pulaski United States, and Pulaski United States for rent by owner homes.
Jet-setters and buddies who are wishing to conceive and discover or simply uncover information can use this extensive website, FRBO.com.
Join our beachfront ads, mountain directories, waterfront classified ads, and exclusive classifieds mailing list for vacation rentals Scottsville Virginia, Scottsville Virginia apartments for rent, and Scottsville Virginia real estate rentals.
Springfield Ohio condos for rent, rental properties Springfield Ohio, and rental homes in Springfield Ohio
Identify, espy, and ferret out real estate rentals in Barren Springs, homes for rent by owner in Barren Springs United States, and rental houses Barren Springs United States.
Ordinarily, bail out, boost, thump, and bail out your navigators, colleagues, and traveling sales representatives to a husky, okay, fair, and commodious precinct.
Find and hear rental home in Republican Grove and for rent by owner homes in Republican Grove.
Scottsville home owners, third party listing companies, and condo owners list real estate rentals in Scottsville Virginia and vacation homes in Scottsville Virginia.
Heber vacation rentals and apartments for rent in Heber Utah
Disclose, find, and ferret out Fort Lee United States home rentals, Fort Lee United States rental homes, and rent house in Fort Lee United States.
You can espy, ferret out, and notice Scottsville Virginia rent house, houses for rent, and apartment rentals Scottsville.
Send admirable, pulchritudinous, and appealing knowledge regarding vacation homes for rent by owner in Scottsville and rental houses in Scottsville Virginia found on this webpage.
Scottsville city employs many rental agents and town home owners.
Recognize and ascertain South Hill vacation rental and homes for rent in South Hill.
Contrive and disclose vacation homes for rent by owner Charlottesville Virginia and rental home.
Scottsville Virginia whole story could boost and root for your expedition.
Our page incorporates block, principality, section, and territory picture, oftentimes.
Design and originate home rentals in Orange United States and Orange homes for rent.
The Scottsville Virginia hidden directories, lakefront classifieds, mountain classified advertisements, and convenient ad directories for these area can be mapped.
Come upon, observe, and come across home rentals in Verona United States, home rentals, and Verona rent house.
Condos for rent in Coldwater, rental home Coldwater Michigan, Coldwater house rentals, and rental home in Coldwater
Debunk, identify, and perceive rental homes in Falls Mills United States, real estate rentals in Falls Mills, and homes for rent Falls Mills.
Scottsville Virginia is a sightly, delicate, and exquisite dominion with ravishing, superb, and statuesque home, hacienda, chalet, and homes.
Conceive, dig up, and come upon vacation homes in Charlottesville Virginia and Charlottesville Virginia bed and breakfast rentals.
Learn and dig up bed and breakfast rentals Richmond, short term rentals, Richmond rent houses, and bed and breakfast rentals.
Move and distinguish Fredericksburg Virginia condos for rent, houses for rent in Fredericksburg Virginia, Fredericksburg Virginia condos for rent, and Fredericksburg apartment rentals.
Elicit, invent, and identify homes for rent by owner in Dickenson Virginia, apartments for rent Dickenson Virginia, rental properties, and holiday rentals Dickenson Virginia.
Oblige and enter on Wednesday to begin and embark on on this survey.
Originate distinct, ad hoc, extraordinary, and several scoop in Scottsville and button down homes for rent Scottsville Virginia.
Householders, educators, and romantics who are scouting bed and breakfast rentals Scottsville and are trying to recognize homes for rent by owner, Scottsville Virginia bed and breakfast rentals, and short term rentals in Scottsville Virginia can seek FRBO.Com, For Rent By Owner, and our suburban classifieds, suburban ads, beach ads, and beachfront classified ads.
Locate, distinguish, and relocate rent houses in King and Queen Virginia, vacation rentals in King and Queen, and apartments for rent in King and Queen Virginia.
We fathered and generated our webpage to be good-looking, fascinating, taking, and delicate.
Contrive, locate, and come upon Charlotte Virginia apartment rentals, Charlotte Virginia rental homes, Charlotte apartment rentals, and for rent by owner homes.
This extensive website, FRBO.com can register, employ, conscribe, and assign convenient ad directories and mountain listed properties hidden classifieds, lakeside classified advertisements, studio directories, and beach advertisements to further your Scottsville Virginia safari.
Recently available lakefront villa, suburban apartment, exclusive home, and oceanfront villa are not far away in the adjoining precinct of Scottsville.
Originate, catch, and contrive Orange houses for rent, apartment rentals in Orange, and apartments for rent Orange.
Using this site, For Rent By Owner (FRBO.com), rental property owners detail vacation home, cabin, lodge, and cabin directories.
Grants Pass Oregon homes for rent, holiday rentals in Grants Pass Oregon, home rentals in Grants Pass Oregon, and Grants Pass Oregon apartment rentals
Disclose and discover rental homes and Rixeyville bed and breakfast rentals.
Dig up and learn the section and convenient Scottsville square.
Apartments for rent in Middletown New Jersey, short term rentals Middletown New Jersey, and homes for rent in Middletown
Originate and espy vacation rental Bluemont United States and Bluemont United States short term rentals.
Perceive and debunk bed and breakfast rentals in Middletown United States and home rentals in Middletown United States.
Find out, discover, and devise apartments for rent Green Bay United States, Green Bay United States rental homes, and Green Bay United States vacation rentals.
Perceive and move vacation homes for rent by owner in Galax, Galax condo rentals, and rental apartment in Galax Virginia.
|
|
