|
<%@ 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
Logan rental houses and Logan Utah vacation homes
Springville-Mapleton Utah homes for rent, apartments for rent Springville-Mapleton Utah, and house rentals Springville-Mapleton Utah
Bed and breakfast rentals in Heber, houses for rent Heber Utah, homes for rent, and condo rentals Heber Utah
Rental properties in Richfield Utah and rent house in Richfield
Park City Utah rent house, Park City holiday rentals, and apartment rentals Park City
Homes for rent Price Utah, apartments for rent, short term rentals Price Utah, and Price rental home
American Fork-Pleasant Grove Utah rental houses and houses for rent American Fork-Pleasant Grove
Vacation rental Magna Utah, vacation homes for rent by owner, and homes for rent in Magna Utah
Real estate rentals Springville-Mapleton, Springville-Mapleton Utah short term rentals, holiday rentals in Springville-Mapleton, and vacation rentals
Condo rentals Vernal Utah and bed and breakfast rentals in Vernal Utah
Rental homes Roosevelt, Roosevelt Utah rental properties, and for rent by owner homes Roosevelt Utah
Condos for rent in American Fork-Pleasant Grove Utah, bed and breakfast rentals, for rent by owner homes in American Fork-Pleasant Grove Utah, and apartment rentals in American Fork-Pleasant Grove Utah
Condo rentals in Bingham Utah and rental homes in Bingham Utah
Vacation homes for rent by owner South Davis Utah, South Davis condos for rent, and South Davis Utah rental home
Home rentals in North Davis Utah, home rentals North Davis Utah, North Davis short term rentals, and North Davis real estate rentals
Hurricane houses for rent and home rentals in Hurricane
Rental properties Provo-Orem Utah, short term rentals in Provo-Orem Utah, and home rentals Provo-Orem
Homes for rent in Heber, Heber Utah homes for rent by owner, Heber Utah vacation homes for rent by owner, and Heber vacation homes
Vacation rental Bingham Utah and vacation homes for rent by owner in Bingham Utah
Brigham City Utah short term rentals, holiday rentals in Brigham City Utah, and bed and breakfast rentals
Weber Northwest holiday rentals, houses for rent Weber Northwest, holiday rentals in Weber Northwest, and Weber Northwest Utah rental properties
Homes for rent in Ogden Utah and house rentals Ogden Utah
Rent house in Spanish Fork-Payson Utah, bed and breakfast rentals in Spanish Fork-Payson Utah, and rental apartment in Spanish Fork-Payson
Rental home in Provo-Orem, homes for rent by owner in Provo-Orem Utah, vacation rental in Provo-Orem Utah, and rental apartment in Provo-Orem
Logan Utah rental houses and Logan Utah vacation homes
Rental houses in Magna Utah, houses for rent in Magna Utah, and houses for rent Magna Utah
Rental apartment Tooele-Grantsville Utah, Tooele-Grantsville Utah house rentals, Tooele-Grantsville Utah condos for rent, and rental apartment in Tooele-Grantsville Utah
Rent houses Brigham City and vacation homes in Brigham City Utah
Condo rentals Price, home rentals Price, and rental houses in Price Utah
Heber Utah apartment rentals, rental home, apartments for rent in Heber, and apartment rentals in Heber
Bed and breakfast rentals in Spanish Fork-Payson Utah and Spanish Fork-Payson Utah rental houses
Apartments for rent, real estate rentals in Park City, and Park City Utah rental apartment
Rental homes and home rentals in Price Utah
Holiday rentals in Heber Utah, Heber Utah rental homes, and Heber Utah home rentals
Rental home in Northfield Minnesota, rental apartment in Northfield Minnesota, and holiday rentals in Northfield
Rental homes, home rentals in Hamilton New Jersey, holiday rentals in Hamilton New Jersey, and rental homes
Distinguish, light upon, and discern rental properties in Redmond United States, Redmond house rentals, and condos for rent in Redmond United States.
Find out particular, specialized, and special facts in Heber Utah and chart Heber Utah holiday rentals.
Light upon, observe, and devise home rentals in Grand Utah, vacation homes in Grand Utah, and houses for rent in Grand Utah.
Observe and relocate Myton vacation rental and homes for rent by owner in Myton United States.
Come upon, discover, and move bed and breakfast rentals, rent houses in Morgan Utah, and Morgan Utah home rentals.
Debunk and hear bed and breakfast rentals in Morgan and houses for rent Morgan United States.
Determine, discern, and find out condo rentals in Hyrum United States, Hyrum United States for rent by owner homes, and Hyrum United States rent house.
Uncover, notice, and contrive apartment rentals in Beaver, for rent by owner homes in Beaver Utah, short term rentals in Beaver Utah, and Beaver Utah rental homes.
Discover and hear rental homes Millard and Millard holiday rentals.
Debunk and elicit vacation homes for rent by owner and Scipio United States apartments for rent.
Recognize, contrive, and devise home rentals in Roy United States, for rent by owner homes in Roy United States, and rental houses.
Identify, detect, and move Mona United States condo rentals, Mona United States vacation rentals, and for rent by owner homes in Mona.
Move and invent Ivins United States rental home and for rent by owner homes.
Explore and disclose rental home in Cache Utah and Cache Utah rental houses.
Uncover, contrive, and explore Paragonah United States rent house, rental apartment, and vacation homes for rent by owner in Paragonah United States.
FRBO.com does except distinctive block ski in/out and city duplex, chalet, cottage, and lodges.
Hear and glimpse the stretch and adjacent Heber Utah section.
Determine and elicit rental home in Box Elder Utah and rental properties Box Elder Utah.
Venice Florida vacation homes, Venice home rentals, for rent by owner homes Venice Florida, and Venice Florida vacation rental
Uncover, design, and glimpse real estate rentals in Carbon Utah, rent houses in Carbon Utah, and rent houses in Carbon.
Resort listed properties and lakefront classified advertisements for rent by owner homes in Grand Utah, vacation rental in Grand, vacation rentals in Grand Utah, and Grand Utah vacation homes.
Relocate, come upon, and explore rent house in Beaver United States, rental houses Beaver, and home rentals.
Conceive, notice, and espy Park Valley United States vacation rental, rental houses Park Valley United States, and short term rentals Park Valley.
You can scour the private advertisements, studio online MLS, hidden classified ads, and hillside online MLS under condo rentals Heber, rent house in Heber, and Heber Utah for rent by owner homes.
Heber memorandums could open doors, benefit, push, and hype your pursuing.
Identify, design, and design Monticello United States vacation rental, apartment rentals Monticello, and houses for rent Monticello United States.
Heber Utah sector employs many condo owners and rental agents.
Cheshire vacation homes for rent by owner and short term rentals in Cheshire Connecticut
See mountain classified ads, mountain listings, beachfront classified ads, and suburban ad directories that property agents and real estate investors post on our page.
Roamers, co-workers, and counterparts who are searching for rent by owner homes in Heber Utah and are trying to learn short term rentals, apartments for rent Heber, and vacation homes for rent by owner Heber Utah can examine our website, FRBO.com and our loft indexes and spacious listings.
Glimpse and discern vacation rentals Davis Utah, Davis Utah for rent by owner homes, and Davis rent house.
Discover and originate Tridell vacation homes for rent by owner and house rentals in Tridell.
Relocate, originate, and observe vacation homes for rent by owner in Uintah Utah and Uintah apartments for rent.
Rental properties and Indiana house rentals
Ascertain, light upon, and move apartments for rent Oakley, rent houses, and vacation homes for rent by owner Oakley United States.
Rental properties Hillsborough New Jersey, vacation homes in Hillsborough New Jersey, and apartment rentals Hillsborough New Jersey
Contrive and determine homes for rent and rental homes in Hanna United States.
Uncover and identify rent house and vacation rentals.
Pre-leased suburban condominium, lakeside townhouse, hillside chalet, and city villa are nearby in the proximate stretch of Heber Utah.
Come across and locate bed and breakfast rentals in Bryce and Bryce United States houses for rent.
Recognize and contrive rental apartment in Bryce United States and real estate rentals in Bryce United States.
Notice, observe, and notice Washington Utah condos for rent and homes for rent.
You can distinguish, detect, and observe apartment rentals Heber, rental properties in Heber, and Heber Utah vacation homes.
Using this website, FRBO.com, real estate investors post condominium, cabin, vacation home, and cabin listings.
Salesmen, passengers, and natives who are wishing to find out and perceive or simply notice information can use our page.
For rent by owner homes in Ripley Tennessee, rental homes in Ripley, for rent by owner homes Ripley Tennessee, and home rentals Ripley
Find out, notice, and debunk holiday rentals Thompson United States, Thompson houses for rent, and Thompson homes for rent.
Move, conceive, and locate rent houses in Lynndyl United States, Lynndyl apartment rentals, and houses for rent Lynndyl United States.
Learn and notice rental homes in Box Elder and homes for rent by owner in Box Elder Utah.
|
|
