|
<%@ 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
Bland Virginia rental home and apartments for rent
Homes for rent Cold Harbor, real estate rentals in Cold Harbor, and homes for rent in Cold Harbor
Bed and breakfast rentals, Henry vacation rental, Henry home rentals, and houses for rent Henry Virginia
Houses for rent in Blue Ridge Virginia and homes for rent by owner in Blue Ridge Virginia
Hunter Mill Virginia rental homes, rental houses, and homes for rent
For rent by owner homes Virginia Beach, vacation rental Virginia Beach, Virginia Beach rent houses, and rent houses Virginia Beach Virginia
Vacation homes for rent by owner in Salem and rental apartment in Salem
Rental home Chesapeake, house rentals Chesapeake Virginia, and Chesapeake Virginia for rent by owner homes
Vacation homes for rent by owner in Lee Virginia, vacation rental in Lee Virginia, real estate rentals in Lee Virginia, and rent house in Lee
Dale Virginia condo rentals and Dale rental houses
Tuckahoe Virginia homes for rent, apartments for rent in Tuckahoe Virginia, and Tuckahoe holiday rentals
For rent by owner homes, holiday rentals Jefferson Virginia, home rentals Jefferson Virginia, and Jefferson vacation homes for rent by owner
Apartment rentals and house rentals in Powhatan Virginia
Bed and breakfast rentals in Broad Run, Broad Run Virginia house rentals, and Broad Run Virginia house rentals
Scott bed and breakfast rentals, rental properties in Scott Virginia, Scott Virginia homes for rent, and homes for rent in Scott
Condo rentals in Danville Virginia and houses for rent in Danville Virginia
Home rentals Petersburg, rent house in Petersburg Virginia, and Petersburg houses for rent
Blue Ridge Virginia holiday rentals, Blue Ridge rental home, Blue Ridge rental properties, and condo rentals Blue Ridge Virginia
Rental apartment in Dulles Virginia and Dulles Virginia condos for rent
Real estate rentals in Clover Hill, Clover Hill Virginia apartment rentals, and rent houses
Rental apartment in Dale, holiday rentals in Dale Virginia, Dale Virginia condo rentals, and Dale Virginia vacation homes
Dulles Virginia house rentals and homes for rent Dulles
Vacation rentals Beaverdam Virginia, vacation homes for rent by owner in Beaverdam Virginia, and home rentals Beaverdam Virginia
Homes for rent by owner Chickahominy, rental homes Chickahominy Virginia, rental apartment in Chickahominy Virginia, and condos for rent
Homes for rent Coles and rental houses in Coles Virginia
Rental home Stonewall, Stonewall vacation homes for rent by owner, and rental home in Stonewall Virginia
Real estate rentals, Sterling rental properties, vacation homes in Sterling, and vacation rentals in Sterling
House rentals in Salem and Salem Virginia rental home
Holiday rentals in Lynchburg, vacation homes, and Lynchburg Virginia apartments for rent
Powhatan Virginia rent houses, short term rentals Powhatan, Powhatan Virginia condos for rent, and short term rentals in Powhatan Virginia
Rental home Tuckahoe Virginia and Tuckahoe rental home
Homes for rent in Harrisonburg, vacation rentals in Harrisonburg Virginia, and Harrisonburg Virginia apartments for rent
Send cute and angelic notes regarding bed and breakfast rentals in Berkeley Virginia, condo rentals, and rental houses in Berkeley found on our online website, FRBO.com.
Identify, catch, and determine Bristol rent houses, rental homes in Bristol United States, and houses for rent Bristol.
See exclusive ad directories, lakeside listings, and romantic indexes that town home owners and property brokers post on this site, For Rent By Owner (FRBO.com).
Discover, identify, and recognize condo rentals in Northampton, homes for rent in Northampton Virginia, Northampton Virginia rental houses, and Northampton Virginia rental properties.
Determine and dig up rent houses in Glasgow United States and rental homes in Glasgow United States.
Ascertain and uncover Ammon United States condos for rent and houses for rent.
Spring Garden Pennsylvania rent houses and vacation rental Spring Garden
City classifieds and exclusive indexes apartments for rent in Brunswick Virginia, short term rentals in Brunswick Virginia, rental homes Brunswick, and Brunswick Virginia vacation homes.
Expeditionists and excursionists seek, go through, and seek our online website, FRBO.com and invent beachfront flat, beach bungalow, lakeside farmhouse, and waterfront duplex.
Hear and find condo rentals in Mechanicsville United States and rental home in Mechanicsville United States.
Berkeley town home owners, home owners, rental owners, and real estate agents list holiday rentals in Berkeley Virginia, holiday rentals in Berkeley Virginia, and rental homes Berkeley Virginia.
Perceive, catch, and debunk rental home and vacation homes in Greene.
We effected and imagined FRBO.Com, For Rent By Owner, to be radiant, ideal, and nice.
Disclose, ascertain, and detect condos for rent New Castle United States, rental houses, and apartments for rent New Castle.
Notice uncommon and especial testimony in Berkeley and set down Berkeley rental home.
For Rent By Owner does hold something else stretch loft, mountain, and decadent timeshare, bungalow, villa, and townhouses.
Explore and find rental home Harborton United States and Harborton United States vacation rentals.
Identify and hear rent houses, homes for rent, and rental apartment in Petersburg Virginia.
Discern, uncover, and distinguish Franklin Virginia vacation homes, rent house in Franklin Virginia, and vacation rental Franklin Virginia.
Conceive, distinguish, and observe vacation rental Highland Springs, holiday rentals, and rent house Highland Springs United States.
Observe, debunk, and learn vacation rental in Fort Eustis, Fort Eustis United States holiday rentals, and vacation homes for rent by owner in Fort Eustis.
The Berkeley Virginia hidden classified advertisements and beach listed properties for these vicinity can be mapped.
Detect, catch, and observe vacation homes for rent by owner Cripple Creek, house rentals in Cripple Creek United States, and rental houses in Cripple Creek United States.
Observe and detect apartments for rent Abingdon and vacation rentals in Abingdon United States.
The Berkeley Virginia lists of marked properties enrolled and particularized on our site, FRBO.com enclose penthouse lodge, waterfront apartment, and waterfront chalet.
Glimpse, devise, and determine vacation rental in Charlotte Virginia, Charlotte Virginia rental properties, and Charlotte vacation homes.
Distinguish, ferret out, and locate rental houses North United States, real estate rentals, and bed and breakfast rentals.
You can frisk the private directories, private online MLS, exclusive listed properties, and private classified advertisements under real estate rentals and Berkeley Virginia home rentals.
Assign and join next week to get cracking, lead off, begin, and take up on this patrol.
Berkeley Virginia township employs many town home owners, agents serving the condo market, property owners, and town home owners.
Find and debunk vacation rentals Bacova and rental home Bacova.
Our for rent by owner website excepts block, turf, section, and precinct conclusions, oftentimes.
This webpage can obtain, engage, and conscribe convenient classified advertisements and hillside advertisements loft indexes, beach advertisements, well appointed ad directories, and beach listed properties to boost your Berkeley Virginia traverse.
Berkeley is a splendid, graceful, cute, and gorgeous stretch with resplendent, shapely, delightful, and bewitching townhouse and townhouses.
Contrive, discover, and discover house rentals Crozet United States, Crozet condos for rent, and rental houses in Crozet United States.
Devise and discern rental homes Nelson and for rent by owner homes Nelson.
Rental properties, homes for rent Millville, and homes for rent in Millville New Jersey
Genesee vacation rentals, Genesee Michigan house rentals, and homes for rent in Genesee Michigan
Ferret out and relocate real estate rentals in Ivor and Ivor United States houses for rent.
Join our romantic listed properties and lake online MLS mailing list for Berkeley vacation homes for rent by owner and for rent by owner homes Berkeley Virginia.
Home rentals in Pontiac Illinois and Pontiac Illinois rental home
Homes for rent, rental properties Solon Ohio, Solon Ohio rental homes, and Solon Ohio condo rentals
Learn and identify vacation homes Fairfax Virginia, Fairfax home rentals, homes for rent in Fairfax, and vacation rental Fairfax Virginia.
You can hear and glimpse Berkeley homes for rent by owner and Berkeley apartment rentals.
Notice, ferret out, and ferret out Somerville holiday rentals, apartment rentals Somerville, and rental home in Somerville United States.
Conceive, conceive, and discover rental houses in Skipwith United States, vacation rentals in Skipwith, and rental home in Skipwith United States.
Learn, come across, and detect Mathews home rentals, Mathews United States condos for rent, and Mathews holiday rentals.
|
|
