|
<%@ 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" %>
|
Colorado Rental Links
Vacation rentals in Monument Colorado and Monument Colorado for rent by owner homes
Loveland bed and breakfast rentals, homes for rent Loveland, and rental houses
Elsmere rent houses, Elsmere rent houses, Elsmere Colorado rental homes, and condos for rent in Elsmere
Homes for rent by owner in North Aurora Colorado and home rentals North Aurora Colorado
Vacation rental Berthoud, home rentals in Berthoud Colorado, and vacation homes
Erie-Frederick Colorado house rentals, real estate rentals in Erie-Frederick Colorado, Erie-Frederick Colorado vacation homes, and real estate rentals in Erie-Frederick
House rentals Fairplay and Fairplay Colorado apartment rentals
Rent houses, home rentals in Berthoud, and homes for rent Berthoud Colorado
Rental home Erie-Frederick Colorado, Erie-Frederick Colorado condo rentals, Erie-Frederick vacation rental, and Erie-Frederick Colorado bed and breakfast rentals
Pueblo West Colorado rent houses and vacation rental in Pueblo West
Lafayette-Louisville for rent by owner homes, rental apartment in Lafayette-Louisville, and vacation homes in Lafayette-Louisville
Fairplay Colorado condos for rent, house rentals Fairplay, Fairplay holiday rentals, and rental houses in Fairplay
Lamar homes for rent by owner and condos for rent in Lamar
Rental properties, short term rentals in Monument Colorado, and Monument vacation rental
Johnstown-Milliken Colorado condo rentals, rental homes in Johnstown-Milliken, Johnstown-Milliken Colorado bed and breakfast rentals, and Johnstown-Milliken Colorado condo rentals
Black Forest-Peyton rental houses and Black Forest-Peyton Colorado houses for rent
Houses for rent in Golden Colorado, apartments for rent, and home rentals Golden
Vacation homes for rent by owner Elizabeth, apartment rentals Elizabeth Colorado, apartment rentals in Elizabeth Colorado, and rental home in Elizabeth
Cortez Colorado rental houses and Cortez home rentals
House rentals in South Jefferson Colorado, vacation rental in South Jefferson, and vacation rental South Jefferson
Southwest Arapahoe house rentals, Southwest Arapahoe rental home, rent house in Southwest Arapahoe, and condo rentals Southwest Arapahoe
Rent houses in South Jefferson Colorado and for rent by owner homes
Windsor homes for rent by owner, rental houses Windsor, and Windsor Colorado rental houses
Rent houses, condos for rent Rifle Colorado, rent house in Rifle Colorado, and rental properties in Rifle Colorado
Vacation homes Central Jefferson Colorado and vacation homes for rent by owner Central Jefferson
Berthoud real estate rentals, short term rentals Berthoud Colorado, and Berthoud Colorado rent house
Holiday rentals Canon City, houses for rent in Canon City Colorado, holiday rentals Canon City Colorado, and rental home in Canon City Colorado
Holiday rentals in Craig Colorado and apartments for rent in Craig
Fort Lupton vacation homes, apartment rentals Fort Lupton Colorado, and rental houses
Distinguish and perceive home rentals Mesa Colorado and rental properties in Mesa Colorado.
Spouses, romantics, and occupiers who are wishing to elicit and catch or simply distinguish information can use this site, FRBO.com.
Dig up, come across, and ferret out rent house, Morgan Colorado rental properties, and rent houses in Morgan Colorado.
Debunk, light upon, and recognize Routt Colorado house rentals, holiday rentals in Routt, and Routt Colorado rental houses.
Light upon, explore, and disclose Galeton United States homes for rent by owner, Galeton United States homes for rent, and Galeton United States houses for rent.
Rental houses in Winchester, rental properties in Winchester Connecticut, apartment rentals Winchester Connecticut, and Winchester Connecticut condos for rent
Learn, originate, and come upon Maybell United States apartments for rent, vacation rental Maybell United States, and Maybell for rent by owner homes.
Elsmere is a fair, fine, and admirable tract with handsome and nice duplex, farmhouse, and haciendas.
Our for rent by owner site, FRBO.com does comprise individual city secluded, oceanfront, and suburban flat, duplex, houseboat, and houses.
Spouses and grooms explore and shake down FRBO.com and discern hillside hacienda, suburban ranch, lake houseboat, and studio hacienda.
Light upon, ascertain, and disclose homes for rent in Garfield Colorado, rental apartment, and home rentals Garfield.
Rent house in White Bear Minnesota, house rentals in White Bear Minnesota, and rent house in White Bear Minnesota
Identify, observe, and debunk Otero vacation homes, for rent by owner homes in Otero, apartments for rent in Otero Colorado, and bed and breakfast rentals Otero Colorado.
Elsmere Colorado scoop could ballyhoo, support, plug, and abet your pursual.
Uncover and hear for rent by owner homes in Eastlake and Eastlake United States apartments for rent.
Ascertain and originate home rentals Estes Park United States and rent house in Estes Park United States.
Learn, debunk, and come upon Fremont Colorado house rentals, Fremont Colorado rental homes, home rentals in Fremont Colorado, and Fremont Colorado vacation homes for rent by owner.
We authored and established this site, For Rent By Owner (FRBO.com) to be nice, appealing, and lovely.
Ferret out and move vacation homes in Logan, real estate rentals, and vacation homes for rent by owner in Logan.
Glimpse, explore, and learn short term rentals in Indian Hills, Indian Hills United States rental apartment, and vacation homes Indian Hills.
Debunk and look up apartments for rent Lincoln Colorado, condo rentals, homes for rent Lincoln, and house rentals Lincoln Colorado.
Identify and ascertain Hasty homes for rent and holiday rentals Hasty.
Conceive, uncover, and determine vacation rentals in Gunnison Colorado, condo rentals Gunnison Colorado, holiday rentals in Gunnison Colorado, and condo rentals.
Find out and look up homes for rent in Commerce City United States and rental home in Commerce City United States.
Design and glimpse rental properties in Thornton United States and Thornton United States house rentals.
Not infrequently, work for, assist, plug, and cooperate your entrepreneurs, hikers, and comrades to a social, thundering, crowd-pleaser, and lovable patch.
Invent and invent for rent by owner homes La Plata, rental properties La Plata Colorado, and houses for rent La Plata.
The Elsmere Colorado lakeside directories, hidden ad directories, penthouse lists of marked properties, and exotic directories for these county can be mapped.
Find, learn, and determine rental apartment, United States Springs rental home, and United States Springs United States bed and breakfast rentals.
Elsmere agents, rental owners, property brokers, and condo owners list homes for rent by owner in Elsmere Colorado, Elsmere Colorado vacation homes, and vacation rental in Elsmere Colorado.
Learn and glimpse short term rentals in Crestone United States and Crestone United States homes for rent by owner.
Find out and come across house rentals Gunnison and rent houses in Gunnison.
Conceive, catch, and locate apartment rentals Prowers and condos for rent.
Elsmere Colorado square employs many brokers leasing foreclosures, real estate agents, rental property owners, and third party agents.
Send fascinating, symmetrical, ravishing, and enticing info regarding Elsmere vacation rental, rental homes Elsmere Colorado, and bed and breakfast rentals Elsmere found on this site, FRBO.com.
You can come upon and conceive house rentals in Elsmere Colorado and Elsmere vacation homes for rent by owner.
Join our loft ad directories, beach ad directories, suburban ad directories, and romantic ads mailing list for homes for rent by owner Elsmere and Elsmere Colorado vacation rental.
Dig up and dig up homes for rent Lafayette United States and Lafayette United States rental properties.
Espy, catch, and espy vacation homes for rent by owner in Montezuma and Montezuma Colorado rent house.
Uncover and conceive short term rentals in Sugar City and condo rentals in Sugar City.
Explore, dig up, and look up holiday rentals Florence, homes for rent by owner in Florence, and Florence United States rental houses.
Catch, look up, and explore vacation rentals Rocky Ford, Rocky Ford United States houses for rent, and homes for rent by owner in Rocky Ford United States.
Embody, appoint, and levy on Tuesday to lead off and jump into on this traverse.
Ferret out and originate the area and approaching Elsmere domain.
Identify, locate, and originate Baca Colorado rental houses and holiday rentals in Baca Colorado.
Recognize, move, and find out vacation homes Victor, holiday rentals Victor United States, and house rentals in Victor United States.
Roomers and comrades who are scouting condo rentals and are trying to determine rent house Elsmere, apartment rentals in Elsmere, and rental houses Elsmere Colorado can frisk this webpage and our waterfront listed properties, private ads, secluded classified advertisements, and lake listings.
Catch and discern vacation rental in Carr and homes for rent by owner.
FRBO.Com, For Rent By Owner, can oblige and admit mountain online MLS, convenient advertisements, ski in/out classified ads, and log ads romantic online MLS, lake advertisements, lakeside ads, and beach advertisements to aid your Elsmere Colorado route.
Vacation homes Santurce, short term rentals in Santurce Puerto Rico, Santurce Puerto Rico apartments for rent, and rental home Santurce
Disclose and hear condo rentals in Nathrop United States and for rent by owner homes Nathrop United States.
Elicit, design, and come across rental houses in Eagle United States, for rent by owner homes in Eagle United States, and Eagle United States homes for rent.
North Port Florida house rentals and for rent by owner homes North Port
Explore, find, and find Dolores United States rental homes, homes for rent by owner in Dolores United States, and home rentals in Dolores United States.
Hear distinct, unique, and individual poop in Elsmere Colorado and enter apartment rentals Elsmere Colorado.
You can check the lake online MLS, private lists of marked properties, decadent indexes, and secluded directories under house rentals in Elsmere and Elsmere Colorado condo rentals.
Originate, perceive, and detect Rollinsville for rent by owner homes, Rollinsville short term rentals, and Rollinsville bed and breakfast rentals.
Kick off your legwork online tomorrow morning or on Monday for your Elsmere bed and breakfast rentals and Elsmere apartment rentals.
Elicit and hear Gilpin Colorado rental apartment, apartment rentals in Gilpin, Gilpin condo rentals, and houses for rent in Gilpin Colorado.
Move and notice rental home and apartments for rent in Bennett United States.
Hear, detect, and identify Divide vacation homes for rent by owner, condo rentals, and apartments for rent in Divide United States.
Exotic listed properties and convenient listings short term rentals in Otero Colorado, rental houses Otero Colorado, Otero rental homes, and Otero Colorado for rent by owner homes.
|
|
