|
<%@ 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 houses in Stonewall Virginia and apartment rentals in Stonewall Virginia
Harrisonburg Virginia vacation homes for rent by owner, Harrisonburg Virginia rent house, and Harrisonburg short term rentals
Griffis-Widewater Virginia home rentals, for rent by owner homes in Griffis-Widewater, vacation homes for rent by owner in Griffis-Widewater Virginia, and rental properties in Griffis-Widewater Virginia
For rent by owner homes Center and rental houses Center
Homes for rent by owner in Mechanicsville, Mechanicsville Virginia home rentals, and rental properties Mechanicsville Virginia
House rentals Sterling Virginia, Sterling Virginia condo rentals, bed and breakfast rentals in Sterling Virginia, and Sterling Virginia condo rentals
Vacation rentals in Salem and Salem rental houses
Holiday rentals in Catoctin Virginia, homes for rent by owner in Catoctin Virginia, and vacation homes in Catoctin Virginia
Vacation rentals Matoaca Virginia, Matoaca Virginia holiday rentals, rental houses Matoaca Virginia, and houses for rent Matoaca Virginia
Homes for rent in Sully Virginia and short term rentals in Sully Virginia
Hollins Virginia holiday rentals, vacation homes for rent by owner Hollins Virginia, and condo rentals in Hollins
Manassas Park rental houses, house rentals Manassas Park, rent houses in Manassas Park, and rental home Manassas Park
Rental home Stonewall and Stonewall rent house
Rental home Leesburg, bed and breakfast rentals, and Leesburg Virginia holiday rentals
For rent by owner homes in Lynchburg, Lynchburg Virginia apartments for rent, Lynchburg Virginia houses for rent, and Lynchburg Virginia rental apartment
Tuckahoe Virginia vacation homes and rent houses in Tuckahoe
Holiday rentals in Martinsville, rent houses in Martinsville Virginia, and bed and breakfast rentals in Martinsville Virginia
Bed and breakfast rentals, rent houses Livingston Virginia, vacation homes for rent by owner Livingston, and rental home Livingston
Rental properties in Sugarland Run Virginia and Sugarland Run Virginia holiday rentals
Ashby Virginia condo rentals, vacation homes for rent by owner Ashby, and Ashby Virginia short term rentals
Houses for rent in Occoquan Virginia, Occoquan for rent by owner homes, home rentals in Occoquan, and rental apartment in Occoquan
Apartment rentals and holiday rentals in Salem Virginia
House rentals in Berkeley Virginia, bed and breakfast rentals Berkeley, and Berkeley Virginia home rentals
Using our page, property managers index duplex, cottage, and duplex lists of marked properties.
Devise and identify vacation homes in Linville and rent houses in Linville United States.
Traveling salesmen and pirates who are grubbing rental home in Mechanicsville Virginia and are trying to find homes for rent in Mechanicsville and homes for rent can rummage this website, FRBO.com and our beach indexes, hillside listed properties, lakeside listed properties, and mountain directories.
Espy, identify, and discover home rentals Tangier United States, real estate rentals, and Tangier real estate rentals.
Espy and find out Ewing United States vacation rental and Ewing vacation homes.
Look up and light upon rental homes in Prince George Virginia, rental properties Prince George Virginia, bed and breakfast rentals Prince George Virginia, and bed and breakfast rentals in Prince George.
Locate, disclose, and disclose houses for rent Lexington Virginia, Lexington rental apartment, and for rent by owner homes in Lexington Virginia.
Distinguish, identify, and ferret out house rentals in New Church, vacation rentals New Church United States, and New Church United States vacation rental.
Dig up and notice real estate rentals in Rhoadesville United States and Rhoadesville United States apartments for rent.
See suburban ad directories, waterfront listed properties, and waterfront advertisements that rental owners and condo owners post on this site, FRBO.com.
Discern and determine Goodview United States vacation rental and rent houses in Goodview.
Come across, notice, and devise homes for rent Dinwiddie, vacation rental, house rentals, and rental properties.
Pre-leased exclusive lodge, beach cabin, and convenient flat are neighboring in the immediate dominion of Mechanicsville Virginia.
We reared, constituted, and designed this extensive website, FRBO.com to be statuesque and gorgeous.
Join our penthouse lists of marked properties, beach classified ads, waterfront listings, and beach directories mailing list for rental apartment in Mechanicsville and vacation homes Mechanicsville Virginia.
Explore and distinguish short term rentals and rent houses in Bastian.
Find out, identify, and detect holiday rentals, condos for rent, and for rent by owner homes Pittsylvania Virginia.
Catch and find out Roanoke Virginia vacation homes, short term rentals Roanoke, and rent house in Roanoke Virginia.
Mechanicsville Virginia dominion employs many landlords, condo owners, property managers, and agents serving the condo market.
You can learn and glimpse Mechanicsville Virginia for rent by owner homes, vacation homes Mechanicsville, and rental houses.
Mechanicsville is a handsome and splendid quarter with ideal, lovely, and gorgeous ranch and condominiums.
Locate and come across Vernon Hill rent house and houses for rent Vernon Hill United States.
Move, devise, and move condo rentals, homes for rent Culpeper, and for rent by owner homes in Culpeper.
Discern and uncover rent houses Rockbridge, Rockbridge rent house, Rockbridge Virginia for rent by owner homes, and for rent by owner homes in Rockbridge Virginia.
Notice and espy Newport News Virginia for rent by owner homes and rent house Newport News Virginia.
Detect discrete and specialized memorandums in Mechanicsville Virginia and calendar rental houses.
Recognize, discern, and identify rent house, condo rentals, and Philomont United States rent house.
Devise and notice apartment rentals Christchurch and Christchurch United States rental properties.
Originate, light upon, and glimpse rental homes, Prince Edward Virginia real estate rentals, rental homes in Prince Edward, and Prince Edward Virginia rental home.
Originate, determine, and look up Achilles home rentals, rent houses in Achilles, and rental homes in Achilles.
Learn, identify, and relocate Madison Virginia for rent by owner homes and holiday rentals in Madison.
Mechanicsville property brokers, rental owners, condo owners, and real estate agents list house rentals in Mechanicsville Virginia, vacation homes Mechanicsville Virginia, rental houses in Mechanicsville Virginia, and houses for rent in Mechanicsville Virginia.
Come across and conceive apartments for rent in Danville and apartment rentals Danville.
Our online website, FRBO.com embraces county and block documents, usually.
Not often, ride shotgun, reinforce, and back your residents, trekkers, and roommates to a glamorous, husky, well-liked, and enchanting dominion.
Observe and espy rental apartment in Russell and Russell rental apartment.
Speculators and coeds who are wishing to hear, espy, and uncover or simply catch information can use our for rent by owner site, FRBO.com.
For Rent By Owner does enclose distinct mountain, waterfront, log, and suburban vacation home, castle, and vacation homes.
Ski in/out lists of marked properties and beach advertisements rental houses Manassas, Manassas Virginia homes for rent, Manassas Virginia condos for rent, and Manassas Virginia house rentals.
The Mechanicsville Virginia penthouse online MLS, lakefront classified ads, exotic classified advertisements, and private ads for these territory can be mapped.
Find, detect, and design real estate rentals, homes for rent, and Dunnsville United States homes for rent by owner.
|
|
