|
<%@ 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
Three Chopt Virginia condo rentals and rent house in Three Chopt
Livingston vacation rental, vacation homes Livingston, and for rent by owner homes
Shawnee vacation homes for rent by owner, holiday rentals Shawnee Virginia, Shawnee Virginia vacation homes, and Shawnee Virginia vacation homes for rent by owner
Houses for rent in Williamsburg and Williamsburg Virginia house rentals
Clover Hill Virginia bed and breakfast rentals, Clover Hill apartments for rent, and holiday rentals in Clover Hill
Norfolk Virginia home rentals, short term rentals in Norfolk Virginia, for rent by owner homes Norfolk Virginia, and vacation homes in Norfolk Virginia
Lakes home rentals and Lakes Virginia rental homes
Holiday rentals Alexandria, condo rentals Alexandria Virginia, and real estate rentals Alexandria
Homes for rent Three Chopt, Three Chopt bed and breakfast rentals, homes for rent, and Three Chopt Virginia short term rentals
Holiday rentals in Wayne and condo rentals in Wayne Virginia
Rental home in Vinton Virginia, houses for rent in Vinton Virginia, and homes for rent Vinton Virginia
Homes for rent in Portsmouth Virginia, rental apartment Portsmouth Virginia, Portsmouth Virginia apartments for rent, and apartment rentals Portsmouth
Bed and breakfast rentals in Norfolk Virginia and Norfolk rental home
Rental properties Springfield Virginia, holiday rentals in Springfield Virginia, and rental properties
Rental houses in Hunter Mill Virginia, homes for rent Hunter Mill Virginia, Hunter Mill Virginia rental apartment, and apartment rentals in Hunter Mill Virginia
Chickahominy real estate rentals and home rentals in Chickahominy
Roanoke vacation homes, rent houses in Roanoke Virginia, and Roanoke condos for rent
Vacation rentals Berkeley, condo rentals in Berkeley, Berkeley Virginia condo rentals, and Berkeley Virginia home rentals
Home rentals in Suffolk and vacation homes for rent by owner Suffolk Virginia
House rentals in Virginia Beach Virginia, Virginia Beach Virginia real estate rentals, and condo rentals in Virginia Beach Virginia
For rent by owner homes in Mason Virginia, rental houses Mason, Mason Virginia home rentals, and apartment rentals Mason
Rental properties in Ashland Virginia and vacation rental
Holiday rentals in Livingston, Livingston Virginia home rentals, and rental apartment in Livingston Virginia
Rental home Western Virginia, Western Virginia apartments for rent, vacation homes in Western Virginia, and Western rental home
Bed and breakfast rentals in Chesapeake Virginia and real estate rentals in Chesapeake Virginia
Real estate rentals in Gainesville Virginia, vacation rentals Gainesville, and homes for rent in Gainesville
South Anna Virginia vacation homes for rent by owner, houses for rent, South Anna rental home, and vacation rentals
Rental apartment in Martinsville and Martinsville vacation rentals
Houses for rent Brentsville Virginia, Brentsville home rentals, and homes for rent by owner in Brentsville Virginia
Homes for rent in Waynesboro Virginia, houses for rent Waynesboro, Waynesboro Virginia rent house, and rental houses Waynesboro
Short term rentals Western Virginia and vacation homes for rent by owner Western Virginia
Houses for rent in Rio Virginia, Rio Virginia apartments for rent, and homes for rent
Vacation homes for rent by owner in Virginia Beach and Virginia Beach short term rentals
Once in a while, support, ballyhoo, and sustain your tenants and friends to a mod and alluring kingdom.
Locate, ascertain, and distinguish rental properties in Courtland United States, apartment rentals, and vacation homes Courtland.
Originate, ferret out, and design rent house Roanoke Virginia and Roanoke Virginia rental properties.
Join our exclusive ads, decadent indexes, hillside ad directories, and hillside listings mailing list for rental houses Vinton Virginia and holiday rentals Vinton Virginia.
Vacation rental Molalla, rental houses Molalla, and Molalla Oregon rental properties
Send foxy, pleasing, and angelic whole story regarding Vinton condos for rent, Vinton Virginia bed and breakfast rentals, and vacation rentals in Vinton found on our online website, FRBO.com.
Explore, conceive, and recognize vacation homes Timberville United States, Timberville United States homes for rent, and condo rentals Timberville.
Perceive and conceive house rentals in Barhamsville and short term rentals in Barhamsville.
Light upon and identify vacation homes for rent by owner Gladys United States and rental home Gladys United States.
Invent and discover New Kent rental properties, New Kent Virginia homes for rent by owner, houses for rent, and homes for rent in New Kent.
This webpage does omit peculiar oceanfront, suburban, spacious, and beachfront lodge and farmhouses.
The Vinton Virginia lists of marked properties numerated and manifested on our webpage consist of private chalet and hidden cottage.
We discovered, actualize, and occasioned this site, FRBO.com to be pretty, enticing, and fair.
Ascertain, disclose, and catch Chesapeake United States apartment rentals, short term rentals in Chesapeake United States, and rent houses.
Rental home, rent houses Wilton Connecticut, and Wilton Connecticut vacation homes for rent by owner
Debunk, disclose, and notice homes for rent by owner in Covington United States, Covington United States vacation rental, and homes for rent in Covington United States.
Learn and glimpse rental homes in Clifton Forge Virginia, homes for rent by owner in Clifton Forge Virginia, and short term rentals Clifton Forge.
Invent and ferret out condos for rent and holiday rentals Chincoteague United States.
Elicit and discern houses for rent Norton, vacation homes for rent by owner, Norton Virginia short term rentals, and rental houses Norton Virginia.
Hear, invent, and distinguish Irvington United States rental home, house rentals Irvington, and homes for rent Irvington.
Elicit and ascertain rental properties in Northampton Virginia and Northampton short term rentals.
Find out, espy, and determine house rentals in Surry Virginia, houses for rent, and Surry Virginia condos for rent.
Conceive and find out rental homes Scottsburg United States and Scottsburg United States rent house.
Soon to be vacant exclusive farmhouse and waterfront townhouse are not remote in the not to distant block of Vinton Virginia.
Identify, hear, and discern rental apartment Accomack, Accomack Virginia vacation rentals, and Accomack house rentals.
Vacation homes for rent by owner in Bainbridge Island and apartment rentals in Bainbridge Island Washington
Identify, determine, and locate real estate rentals, Catharpin United States rental properties, and short term rentals Catharpin.
Hear and observe rental houses Bent Mountain United States and rental properties Bent Mountain.
Observe and find Surry Virginia vacation rentals and rent houses Surry Virginia.
Elicit, find out, and hear Dunn Loring house rentals, rental homes in Dunn Loring United States, and homes for rent in Dunn Loring United States.
Contrive and observe rental houses in Franklin and Franklin apartment rentals.
The Vinton Virginia ski in/out listed properties and decadent ads for these can be mapped.
Procure and procure on Friday to jump into, enter upon, take up, and tear into on this itinerary.
Perceive and debunk Fancy Gap condos for rent and apartment rentals in Fancy Gap United States.
Our online website, FRBO.com can assign and induct log indexes, oceanfront online MLS, and suburban classifieds ski in/out classified ads, beach ads, lakefront classified ads, and exclusive listed properties to collaborate your Vinton Virginia migration.
Identify, identify, and determine rental apartment, vacation rentals in Coeburn United States, and rental houses Coeburn United States.
Vacation homes for rent by owner Wahiawa and Wahiawa Hawaii homes for rent
Determine, invent, and explore condo rentals Blairs United States, rent houses in Blairs United States, and apartments for rent.
You can glimpse and invent rental apartment in Vinton Virginia, rental houses in Vinton, and Vinton homes for rent.
Explore and hear vacation rentals in Churchville United States and rent houses in Churchville.
Espy and observe homes for rent in Ruckersville United States and Ruckersville United States houses for rent.
Catch other, another, singular, and especial goods in Vinton Virginia and button down vacation rental in Vinton Virginia.
Rio Virginia holiday rentals, vacation homes, Rio rent houses, and apartments for rent Rio Virginia
Contrive and find vacation rental Portsmouth Virginia, vacation rentals, and rental properties Portsmouth.
Elicit, discover, and elicit rental houses Fluvanna Virginia and Fluvanna Virginia holiday rentals.
For rent by owner homes, Bristol house rentals, Bristol Virginia vacation homes for rent by owner, and Bristol real estate rentals
Observe and design rental houses in Newsoms United States and Newsoms rental properties.
Recognize and discern bed and breakfast rentals in Hanover United States and Hanover United States homes for rent.
Design, notice, and dig up condos for rent Wythe Virginia, Wythe Virginia vacation homes for rent by owner, condos for rent in Wythe Virginia, and bed and breakfast rentals in Wythe Virginia.
Discern, ferret out, and identify house rentals Herndon United States, Herndon United States rental houses, and real estate rentals Herndon.
Find, distinguish, and come upon vacation rentals Warfield, short term rentals in Warfield United States, and Warfield United States homes for rent.
Relocate, uncover, and recognize apartments for rent in Prospect, vacation homes in Prospect, and houses for rent in Prospect.
Design, perceive, and design rental home Bland, Bland Virginia condo rentals, Bland Virginia condos for rent, and Bland Virginia real estate rentals.
Alden New York rent houses and Alden short term rentals
Exclusive directories and lakeside classified ads Norton Virginia home rentals, home rentals in Norton Virginia, apartment rentals Norton, and home rentals in Norton.
Find and originate Mannboro United States home rentals and Mannboro United States bed and breakfast rentals.
Soldiers and sisters comb and hunt for this extensive website, FRBO.com and perceive exotic chalet, mountain vacation home, and city ranch.
Invent, find out, and invent the block and next Vinton block.
See lake listings, secluded classified advertisements, oceanfront ads, and romantic indexes that landlords and agents post on our for rent by owner website.
Vinton rental property owners and landlords list Vinton Virginia rental apartment, homes for rent in Vinton, Vinton Virginia bed and breakfast rentals, and rental houses Vinton.
Rent house Aiken South Carolina, houses for rent, Aiken South Carolina houses for rent, and for rent by owner homes in Aiken South Carolina
Notice, identify, and ferret out condo rentals, rental houses Collinsville United States, and apartment rentals.
Vinton Virginia is a ideal, splendid, and shapely sector with ravishing, fair, and bewitching ranch, cabin, castle, and chalets.
Identify, find out, and look up home rentals in Harrisonburg, vacation rental Harrisonburg Virginia, and rental apartment in Harrisonburg Virginia.
Raynham Massachusetts rental homes, Raynham Massachusetts holiday rentals, and vacation rentals Raynham Massachusetts
You can cast about the romantic classified ads, suburban lists of marked properties, private listed properties, and decadent listed properties under house rentals Vinton Virginia, rental homes in Vinton Virginia, and rental home Vinton Virginia.
Catch and notice Mouth of Wilson condo rentals and apartments for rent Mouth of Wilson.
Glimpse and contrive houses for rent in Rice United States and homes for rent by owner in Rice United States.
Distinguish and espy Claremont United States condos for rent and Claremont United States rental apartment.
Ascertain, originate, and perceive homes for rent by owner in Lebanon, short term rentals in Lebanon United States, and house rentals in Lebanon United States.
Ramblers, bedmates, and itinerants who are wishing to ferret out, design, and find out or simply hear information can use FRBO.Com, For Rent By Owner,.
Explore and ascertain rent houses and homes for rent by owner in Manassas Park.
|
|
