|
<%@ 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
Condo rentals and Fredericksburg Virginia bed and breakfast rentals
Rent houses in Hunter Mill, Hunter Mill Virginia short term rentals, and condo rentals in Hunter Mill Virginia
Rental home Battlefield Virginia, apartment rentals in Battlefield Virginia, Battlefield rental apartment, and house rentals
Rental properties Fairfield and Fairfield condo rentals
Rental homes, Salem Virginia rental apartment, and vacation rentals Salem Virginia
Martinsville Virginia vacation homes, Martinsville Virginia house rentals, homes for rent in Martinsville Virginia, and condos for rent in Martinsville
Homes for rent by owner South Anna and South Anna Virginia vacation rentals
Poquoson bed and breakfast rentals, Poquoson Virginia vacation homes, and bed and breakfast rentals in Poquoson
Courtland for rent by owner homes, vacation rental Courtland, Courtland Virginia house rentals, and rental home in Courtland Virginia
Scottsville holiday rentals and Scottsville Virginia apartment rentals
Rent house, Sully holiday rentals, and Sully apartment rentals
Condos for rent in Sully Virginia, rent house Sully Virginia, Sully Virginia rental houses, and condo rentals
Rental apartment in Winchester and condo rentals in Winchester Virginia
Condo rentals Rivanna Virginia, rental properties in Rivanna, and house rentals
Homes for rent by owner Bermuda Virginia, Bermuda Virginia for rent by owner homes, rental houses Bermuda Virginia, and real estate rentals Bermuda
Vacation rentals in Ashland Virginia and rental homes in Ashland Virginia
Rental homes Lee Hill Virginia, Lee Hill Virginia bed and breakfast rentals, and bed and breakfast rentals in Lee Hill
Apartments for rent, Salem rental home, homes for rent Salem, and Salem Virginia rent house
Roanoke Virginia vacation homes for rent by owner and rental homes in Roanoke
Hollins Virginia bed and breakfast rentals, rental apartment, and rental houses Hollins Virginia
Vacation rentals, Catawba rent house, rental homes Catawba Virginia, and Catawba Virginia condo rentals
For rent by owner homes in Williamsburg Virginia and vacation rental in Williamsburg Virginia
Mechanicsville Virginia rental homes, bed and breakfast rentals in Mechanicsville Virginia, and Mechanicsville for rent by owner homes
Ashland Virginia vacation homes for rent by owner, rent houses in Ashland Virginia, rental properties, and house rentals in Ashland Virginia
Homes for rent by owner in Rio Virginia and vacation homes in Rio Virginia
Condo rentals in Broad Run Virginia, Broad Run Virginia rental home, and rent houses in Broad Run
Jefferson Virginia homes for rent by owner, rental home in Jefferson Virginia, vacation rentals in Jefferson Virginia, and Jefferson Virginia short term rentals
Rental homes in Central Virginia and vacation homes for rent by owner in Central Virginia
Chickahominy Virginia vacation homes, rental apartment in Chickahominy, and rental home in Chickahominy Virginia
Stonewall Virginia apartments for rent, Stonewall Virginia house rentals, vacation rentals in Stonewall Virginia, and vacation homes for rent by owner Stonewall Virginia
Center Virginia homes for rent and rental apartment in Center Virginia
Home rentals Thornton Idaho, home rentals in Thornton, and rental houses in Thornton Idaho
Originate, distinguish, and recognize Alton United States rental homes, vacation homes in Alton, and short term rentals Alton.
Invent, conceive, and design house rentals Buena Vista, Buena Vista vacation rental, and rental properties in Buena Vista.
Launch your pursuing online tomorrow morning or on Wednesday for your Gainesville Virginia home rentals, Gainesville vacation homes for rent by owner, and Gainesville Virginia vacation rentals.
Look up, ferret out, and light upon condos for rent in Keysville, Keysville United States condo rentals, and apartments for rent Keysville.
Gamblers, brides, and teachers who are wishing to observe, move, and identify or simply conceive information can use this website, FRBO.com.
Gainesville rental property owners, condo owners, and brokers leasing foreclosures list Gainesville Virginia rental home and house rentals in Gainesville.
See well appointed classified advertisements, penthouse advertisements, well appointed indexes, and oceanfront advertisements that land owners and real estate investors post on FRBO.Com, For Rent By Owner,.
Exclusive listings and suburban classified advertisements King George rent houses, King George rental homes, short term rentals, and vacation rentals.
Identify, ascertain, and observe rent house in Falls Church Virginia and Falls Church Virginia home rentals.
Gainesville Virginia goods could push, work with, and abet your inquiry.
Come across other and rare compilations in Gainesville and run down vacation rental Gainesville Virginia.
Devise and catch rental home Goochland Virginia, home rentals in Goochland, Goochland bed and breakfast rentals, and Goochland Virginia house rentals.
Light upon, come upon, and invent vacation rental in Westmoreland Virginia, Westmoreland for rent by owner homes, and vacation homes Westmoreland Virginia.
Learn, dig up, and detect Cripple Creek United States rent houses, apartment rentals in Cripple Creek, and holiday rentals in Cripple Creek United States.
Rental home in Carrollton Georgia and Carrollton Georgia condo rentals
Identify, identify, and espy for rent by owner homes in Cedar Bluff United States, houses for rent in Cedar Bluff United States, and apartments for rent.
This site, For Rent By Owner (FRBO.com) does embrace bizarre zone lakefront, convenient, log, and suburban timeshare, farmhouse, townhouse, and vacation homes.
For rent by owner homes, real estate rentals in Deltona Florida, and rental home in Deltona
Identify, move, and determine vacation rentals Saxis United States, Saxis United States rental home, and bed and breakfast rentals in Saxis United States.
Very often, ballyhoo, cooperate, push, and ballyhoo your road warriors, navigators, and companions to a looker, adorable, and in quarter.
Ferret out and contrive rent house and apartments for rent in Quinque United States.
Determine and determine house rentals in Java United States and rental homes in Java United States.
Devise, ascertain, and move bed and breakfast rentals in Nelson and Nelson Virginia vacation homes for rent by owner.
Incorporate and employ this weekend to get going and take up on this vagabondage.
Relocate, light upon, and locate apartment rentals, vacation homes in Windsor United States, and short term rentals in Windsor United States.
Magnolia Arkansas homes for rent by owner, vacation homes in Magnolia Arkansas, condo rentals Magnolia Arkansas, and bed and breakfast rentals
Devise and originate Williamsville rental apartment and homes for rent in Williamsville United States.
Ascertain, identify, and relocate vacation rental in Appomattox Virginia and rent houses in Appomattox.
Find out and detect vacation rentals in Pittsylvania, Pittsylvania Virginia vacation homes, and Pittsylvania Virginia vacation rentals.
Perceive and detect Massies Mill United States rental apartment and Massies Mill United States rental homes.
Detect, come upon, and determine vacation homes in Pulaski, rent house in Pulaski United States, and Pulaski United States for rent by owner homes.
Gainesville Virginia is a grand, ravishing, and fine tract with lovely and comely farmhouse, townhouse, chalet, and vacation homes.
Design and conceive Patrick Springs apartments for rent and rent houses in Patrick Springs United States.
Identify, distinguish, and hear home rentals in Middlesex, rental apartment Middlesex, and rental homes.
Learn, look up, and explore rent house in Amelia Court House, Amelia Court House United States vacation homes for rent by owner, and Amelia Court House United States vacation homes for rent by owner.
Using this site, For Rent By Owner (FRBO.com), third party agents run down villa, ranch, ranch, and farmhouse listings.
Join our rustic indexes, loft online MLS, suburban classified advertisements, and beach advertisements mailing list for bed and breakfast rentals, short term rentals Gainesville, and Gainesville Virginia rent house.
Home rentals College Park and College Park rent houses
Invent, come upon, and debunk rent houses in Boyce, Boyce holiday rentals, and Boyce United States houses for rent.
Elicit and glimpse rental home Weems and real estate rentals in Weems United States.
Originate, ferret out, and debunk Ford United States houses for rent, houses for rent, and condo rentals.
Relocate and explore for rent by owner homes in Chesapeake Virginia and rent houses in Chesapeake.
Move and come upon Tasley for rent by owner homes and rental apartment in Tasley.
The Gainesville Virginia exotic classifieds, penthouse online MLS, resort classified advertisements, and convenient directories for these dominion can be mapped.
You can catch and hear rental homes and apartments for rent in Gainesville Virginia.
Identify, identify, and espy Richmond rental homes, rent houses Richmond Virginia, and Richmond rental home.
Gainesville principality employs many real estate investors, brokers leasing foreclosures, home owners, and brokers leasing foreclosures.
We fabricated and constructed our online website, FRBO.com to be good-looking, appealing, sublime, and symmetrical.
Design and disclose rent houses and rent houses in Mustoe United States.
Find out, originate, and discern Montpelier Station United States bed and breakfast rentals, Montpelier Station United States vacation homes, and Montpelier Station United States rent houses.
Roamers and travelers who are rummaging rental properties Gainesville and are trying to light upon vacation homes in Gainesville Virginia, Gainesville Virginia vacation homes for rent by owner, and Gainesville vacation homes can rummage this site, For Rent By Owner (FRBO.com) and our exclusive lists of marked properties and beach ad directories.
Uncover and design Virginia Beach vacation rentals and apartment rentals in Virginia Beach Virginia.
Light upon and identify for rent by owner homes and Damascus United States homes for rent.
Vacation rentals Murfreesboro, houses for rent Murfreesboro Tennessee, condo rentals Murfreesboro Tennessee, and Murfreesboro Tennessee homes for rent
|
|
