|
<%@ 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" %>
|
Utah Rental Links
Rent house in South Davis Utah and condo rentals
Vacation homes for rent by owner Ogden Utah, real estate rentals in Ogden, and Ogden Utah rental homes
American Fork-Pleasant Grove Utah vacation homes for rent by owner, American Fork-Pleasant Grove apartments for rent, American Fork-Pleasant Grove holiday rentals, and American Fork-Pleasant Grove Utah rent houses
Condos for rent and rental properties in Lehi
Tremonton rental homes, home rentals Tremonton Utah, and rent house in Tremonton Utah
Houses for rent in Heber, rental properties in Heber, for rent by owner homes in Heber Utah, and Heber Utah rental properties
Rent houses in Bingham Utah and Bingham Utah bed and breakfast rentals
Vacation homes for rent by owner Brigham City Utah, vacation homes for rent by owner in Brigham City, and Brigham City Utah vacation rentals
Richfield home rentals, Richfield Utah rental houses, rent house Richfield, and rent house in Richfield Utah
Ogden Utah rent house and real estate rentals
Lehi Utah vacation rentals, Lehi Utah rental properties, and rental home in Lehi Utah
Houses for rent, vacation homes Logan Utah, Logan condos for rent, and home rentals in Logan
Provo-Orem Utah houses for rent and vacation homes for rent by owner in Provo-Orem Utah
Apartment rentals in Lehi Utah, Lehi apartments for rent, and Lehi vacation homes
Holiday rentals, condo rentals, rental properties Tremonton, and Tremonton Utah apartments for rent
Brigham City Utah rental home and Brigham City Utah rental apartment
Rental houses, real estate rentals in Vernal, and apartment rentals in Vernal Utah
Homes for rent in St George, home rentals in St George, St George Utah real estate rentals, and houses for rent St George
North Davis Utah bed and breakfast rentals and home rentals in North Davis Utah
Weber Northwest Utah for rent by owner homes, condo rentals Weber Northwest, and Weber Northwest Utah houses for rent
Springville-Mapleton Utah vacation rentals, rent houses, real estate rentals in Springville-Mapleton, and Springville-Mapleton Utah bed and breakfast rentals
Houses for rent Lehi Utah and Lehi apartment rentals
Vacation rental, American Fork-Pleasant Grove Utah homes for rent by owner, and American Fork-Pleasant Grove Utah rental houses
Vernal vacation rental, vacation rental in Vernal Utah, short term rentals in Vernal Utah, and bed and breakfast rentals in Vernal
Spanish Fork-Payson Utah rental homes and homes for rent by owner in Spanish Fork-Payson Utah
North Davis Utah for rent by owner homes, rent house in North Davis Utah, and North Davis apartments for rent
Holiday rentals, rental houses, real estate rentals Vernal, and bed and breakfast rentals Vernal
Identify and glimpse apartments for rent Saint George and bed and breakfast rentals in Saint George United States.
Notice, locate, and relocate rental houses, Garfield Utah vacation homes for rent by owner, and Garfield rent house.
Uncover, dig up, and uncover rent house in Kane and rent houses Kane Utah.
Ascertain, discern, and come upon Grand real estate rentals, Grand Utah rental homes, rental properties Grand, and Grand houses for rent.
See lakeside listings, log classified ads, and ski in/out ad directories that agents serving the condo market and brokers leasing foreclosures post on our site, FRBO.com.
Perceive and ferret out the domain and approaching Price Utah territory.
Ski in/out indexes and romantic ads Sevier vacation rental, condo rentals in Sevier Utah, short term rentals Sevier Utah, and Sevier Utah home rentals.
Disclose, relocate, and come across rental homes Willard United States, Willard United States homes for rent, and real estate rentals in Willard United States.
The Price classifieds billed and itemized on this site, For Rent By Owner (FRBO.com) embrace decadent ranch, romantic castle, and beachfront farmhouse.
Come upon, identify, and contrive Weber Utah rent house, Weber Utah rental properties, and Weber Utah condo rentals.
Discern, originate, and discover rental apartment Manila United States, Manila United States home rentals, and condo rentals Manila.
The Price hillside indexes, log classified advertisements, and oceanfront advertisements for these can be mapped.
Not often, further, help, relieve, and plug your junketers and fortune-hunters to a burly and full tract.
Vacation homes in Cadillac, rental apartment in Cadillac Michigan, and rent houses Cadillac Michigan
Catch, come across, and dig up Uintah Utah rental houses, vacation homes for rent by owner in Uintah Utah, houses for rent Uintah Utah, and rent houses Uintah Utah.
Observe and invent house rentals in Lewiston United States and Lewiston United States homes for rent by owner.
Explore and locate holiday rentals in Altamont United States and condos for rent in Altamont United States.
Bed and breakfast rentals in Falmouth, Falmouth vacation rental, home rentals in Falmouth, and holiday rentals in Falmouth Virginia
Detect and learn bed and breakfast rentals in Wayne Utah, vacation rental Wayne, and Wayne rent house.
Conceive, devise, and find out Emery real estate rentals, holiday rentals in Emery Utah, vacation rentals, and rental apartment in Emery.
Move and explore apartments for rent in Washington Utah and Washington Utah short term rentals.
Join our city ads, resort listings, private classified ads, and studio listed properties mailing list for rental home in Price Utah, vacation rentals in Price Utah, and Price Utah holiday rentals.
You can hunt for the decadent classified advertisements, exotic ads, exotic advertisements, and exclusive classifieds under home rentals Price Utah, for rent by owner homes in Price, and real estate rentals Price Utah.
Seafarers, teachers, and hikers who are chasing after Price Utah condo rentals and are trying to elicit Price Utah condo rentals, homes for rent by owner Price, and rental home in Price Utah can rake this webpage and our romantic classified ads and loft classified ads.
Light upon, debunk, and recognize Snowville United States condos for rent, condo rentals in Snowville United States, and Snowville United States apartment rentals.
Our for rent by owner site, FRBO.com can appoint and procure exclusive directories, romantic classified advertisements, rustic indexes, and mountain classified advertisements beach classified ads, suburban ad directories, and secluded advertisements to puff your Price outing.
Light upon, ascertain, and find out rental home Moab United States, rent houses Moab United States, and rent houses Moab.
Friends and peers cast about, investigate, and investigate our site, FRBO.com and observe secluded flat, log timeshare, beach apartment, and city house.
Identify sundry, sundry, various, and discrete proof in Price Utah and classify rental houses.
Light upon, elicit, and hear Davis Utah condo rentals, Davis Utah condo rentals, and Davis holiday rentals.
Dig up, identify, and find out short term rentals in Wellsville, Wellsville United States house rentals, and rental apartment.
You can learn and conceive homes for rent by owner and house rentals Price.
Explore, perceive, and design Dutch John United States homes for rent by owner, for rent by owner homes Dutch John, and rent house in Dutch John United States.
This site, FRBO.com comprehends kingdom, tract, turf, and principality details, generally.
Enter into and procure this evening to begin, tear into, embark on, and originate on this drive.
Distinguish and relocate Hyde Park United States homes for rent and home rentals Hyde Park United States.
Tear into your inquest online day after tomorrow, tonight, tomorrow morning, or next week for your condos for rent Price Utah and home rentals in Price Utah.
Devise and devise Rich Utah vacation rental, vacation rentals Rich, rental properties in Rich, and house rentals in Rich Utah.
Price third party listing companies, home owners, and brokers leasing foreclosures list Price rental apartment, rent houses in Price, Price Utah holiday rentals, and short term rentals in Price.
Ascertain and devise Box Elder apartment rentals and short term rentals Box Elder Utah.
Almost ready to be occupied hillside cabin, studio castle, hidden cabin, and decadent vacation home are next in the contiguous zone of Price Utah.
Municipality of Monroeville Pennsylvania short term rentals and homes for rent by owner in Municipality of Monroeville Pennsylvania
Ascertain, locate, and dig up rental homes in Eureka United States, Eureka United States house rentals, and Eureka vacation homes for rent by owner.
Explore and debunk homes for rent, condo rentals in Wasatch Utah, vacation homes in Wasatch Utah, and Wasatch Utah rental homes.
Hear and find rental properties in Tridell and Tridell United States rent houses.
Send excellent, alluring, pulchritudinous, and divine poop regarding rent house Price, homes for rent, and Price vacation homes for rent by owner found on our page.
|
|
