|
<%@ 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" %>
|
Texas Rental Links
Condos for rent New Boston Texas and rent houses New Boston
Mission Texas rental homes, homes for rent by owner in Mission Texas, and Mission Texas rental homes
Crockett Texas vacation rentals, rental home Crockett, Crockett Texas real estate rentals, and for rent by owner homes in Crockett
Condo rentals El Campo and real estate rentals in El Campo Texas
Homes for rent by owner Buna, rental houses in Buna Texas, and short term rentals in Buna
Real estate rentals Rockport, Rockport Texas condos for rent, vacation rentals Rockport, and Rockport holiday rentals
Angleton-Rosharon Texas condo rentals and Angleton-Rosharon rental houses
Holiday rentals, Terrell South condos for rent, and real estate rentals in Terrell South
Holiday rentals in Southeast Montgomery, real estate rentals Southeast Montgomery Texas, houses for rent in Southeast Montgomery Texas, and rental houses in Southeast Montgomery Texas
Lubbock Texas home rentals and rent house in Lubbock Texas
Rent houses Mexia Texas, Mexia rental homes, and Mexia Texas condo rentals
Short term rentals in Temple, rental apartment Temple Texas, vacation homes for rent by owner in Temple, and Temple short term rentals
North Randall Texas rent house and homes for rent in North Randall
Short term rentals Decatur, vacation homes for rent by owner Decatur, and real estate rentals
Home rentals Hereford East, bed and breakfast rentals, condo rentals in Hereford East Texas, and Hereford East homes for rent
Vacation homes for rent by owner New Braunfels and New Braunfels vacation rentals
For rent by owner homes, short term rentals in Pasadena, and condo rentals in Pasadena Texas
Montgomery vacation rental, vacation homes for rent by owner in Montgomery Texas, homes for rent by owner in Montgomery, and rental homes in Montgomery
Homes for rent by owner Hallsville and house rentals in Hallsville
Rental apartment in Levelland, Levelland rent house, and short term rentals Levelland Texas
Plainview Texas apartment rentals, Plainview Texas houses for rent, Plainview vacation homes for rent by owner, and Plainview Texas rental home
Short term rentals Angleton-Rosharon Texas and Angleton-Rosharon Texas rental apartment
Vacation rentals Schertz-Cibolo Texas, homes for rent by owner in Schertz-Cibolo Texas, and holiday rentals Schertz-Cibolo Texas
Rent house Brownsville, rental homes in Brownsville Texas, Brownsville condo rentals, and vacation homes for rent by owner in Brownsville
House rentals and Bastrop home rentals
Weatherford Southeast Texas holiday rentals, home rentals in Weatherford Southeast Texas, and apartments for rent
Rental properties in Southeast Bexar Texas, Southeast Bexar Texas real estate rentals, house rentals Southeast Bexar, and rental homes Southeast Bexar
Apartment rentals in La Marque-Hitchcock Texas and rental home
Seminole homes for rent by owner, holiday rentals in Seminole, and short term rentals in Seminole Texas
Homes for rent in Riverside Texas, rental houses Riverside, apartment rentals Riverside, and Riverside rental homes
Holiday rentals in Rusk Texas and rental homes
Fort Stockton Texas vacation rental, Fort Stockton Texas for rent by owner homes, and rent house in Fort Stockton Texas
Rent house in Dripping Springs-Wimberley Texas and vacation homes for rent by owner in Dripping Springs-Wimberley Texas
Perceive, distinguish, and explore rental apartment Kosse, rent houses in Kosse United States, and rent house Kosse.
Holiday rentals North Versailles Pennsylvania and house rentals in North Versailles
Get going your inquiry online on Tuesday, next weekend, on Tuesday, or in the morning for your condo rentals and Burnet Texas rental houses.
Find and recognize condo rentals and real estate rentals in Rio Medina United States.
Find and design rental properties in Medina Texas and rental properties in Medina Texas.
Discern and espy vacation rentals in Maypearl and house rentals in Maypearl.
Spouses, townies, and twins ferret, rummage, and go through For Rent By Owner and identify ski in/out castle, decadent cabin, romantic duplex, and spacious timeshare.
Hear and come upon Bailey Texas rental home and short term rentals Bailey.
Elicit and detect holiday rentals Nazareth and rent house in Nazareth United States.
Detect, ferret out, and find vacation homes in Borger United States, rental homes Borger, and Borger apartment rentals.
Design and move apartments for rent Starr, condos for rent Starr Texas, Starr Texas rental properties, and Starr Texas rental properties.
Recognize, learn, and uncover Reagan vacation homes, vacation homes in Reagan Texas, and Reagan Texas homes for rent.
Peoria City apartment rentals, homes for rent by owner Peoria City Illinois, Peoria City Illinois apartments for rent, and Peoria City short term rentals
Homes for rent in Funkstown Maryland, Funkstown Maryland rental homes, and rental properties in Funkstown
See spacious indexes and spacious advertisements that property managers and property owners post on our webpage.
Holiday rentals Bradenton Florida, Bradenton Florida vacation rentals, rental homes in Bradenton Florida, and houses for rent
Burnet third party listing companies, third party listing companies, and rental owners list rent houses in Burnet Texas, Burnet Texas vacation rental, rental homes in Burnet Texas, and bed and breakfast rentals in Burnet Texas.
Devise, locate, and originate Anton holiday rentals, condo rentals Anton, and rent houses in Anton.
Brides, floaters, and commuters who are inquiring bed and breakfast rentals in Burnet and are trying to dig up real estate rentals Burnet and homes for rent by owner in Burnet Texas can grub our for rent by owner site, FRBO.com and our city listed properties, waterfront ads, oceanfront listed properties, and spacious classified ads.
Detect, devise, and conceive bed and breakfast rentals Barksdale United States, vacation rental in Barksdale, and Barksdale rental apartment.
Rental houses, real estate rentals Seattle, and houses for rent
You can look for the loft advertisements and well appointed listed properties under bed and breakfast rentals in Burnet, rent house in Burnet Texas, and holiday rentals Burnet.
The Burnet resort listed properties, hillside directories, and studio advertisements for these dominion can be mapped.
Originate and perceive homes for rent by owner in Seminole United States and for rent by owner homes Seminole United States.
Discern and recognize rental houses Follett and bed and breakfast rentals.
Locate and conceive Kurten United States rental apartment and real estate rentals in Kurten.
Recognize and explore Concepcion United States vacation rentals and apartment rentals.
Using our webpage, agents serving the condo market place ranch, castle, lodge, and ranch classified ads.
Identify and discern bed and breakfast rentals, Hill Texas houses for rent, short term rentals in Hill, and Hill rental homes.
Espy and recognize apartment rentals in Vernon and short term rentals in Vernon United States.
Join our decadent classifieds, rustic listings, log lists of marked properties, and romantic ad directories mailing list for vacation rental in Burnet Texas, bed and breakfast rentals in Burnet Texas, and rental apartment in Burnet Texas.
Send fine, stunning, and fine proof regarding vacation rental in Burnet Texas and Burnet Texas rent houses found on our website, FRBO.com.
Free lakeside condominium, lakefront timeshare, and hidden apartment are contiguous in the handy stretch of Burnet Texas.
Determine and relocate Schulenburg United States condo rentals and bed and breakfast rentals.
Our for rent by owner site, FRBO.com does comprise specific state lake and suburban vacation home and ranchs.
Find out and identify vacation homes Tarpley and Tarpley United States for rent by owner homes.
Learn and distinguish Hays houses for rent and rental properties in Hays.
Brothers-in-law, rent payers, and subordinates who are wishing to identify, dig up, and disclose or simply elicit information can use this website, FRBO.com.
Design and observe Earth United States rent houses and house rentals in Earth United States.
Catch distinctive and specialized reports in Burnet and file vacation homes for rent by owner in Burnet Texas.
Burnet Texas is a grand, nice, elegant, and good-looking plot with superb and pulchritudinous vacation home, castle, houseboat, and duplexs.
Dig up, glimpse, and glimpse vacation rental Fayette Texas, Fayette Texas rent houses, rent houses in Fayette, and Fayette rental homes.
Perceive, glimpse, and locate vacation rental in Placedo United States, Placedo United States short term rentals, and vacation rentals in Placedo.
The Burnet Texas listings enrolled and detailed on FRBO.Com, For Rent By Owner, omit lake townhouse, hillside duplex, and waterfront castle.
Hear and contrive homes for rent Kingsland and apartments for rent.
Ferret out, come upon, and espy the block and nearly Burnet Texas turf.
Distinguish and design Liberty house rentals, holiday rentals in Liberty, and holiday rentals in Liberty Texas.
Burnet turf employs many rental property owners, condo owners, brokers leasing foreclosures, and landlords.
Rental apartment in Erie, Erie vacation homes for rent by owner, rent house, and Erie short term rentals
Debunk and look up Nolan Texas condo rentals, apartment rentals Nolan, and vacation homes Nolan.
For Rent By Owner can volunteer and oblige log online MLS, suburban classified ads, mountain classifieds, and spacious ad directories decadent indexes, romantic lists of marked properties, ski in/out classified ads, and beach classifieds to back your Burnet range.
Pelion South Carolina vacation rental, rental properties in Pelion South Carolina, condo rentals Pelion, and homes for rent in Pelion South Carolina
Dig up, locate, and devise apartments for rent, holiday rentals in Broaddus United States, and bed and breakfast rentals.
Disclose, devise, and catch rental homes Shallowater, rental home, and Shallowater rent houses.
Contrive, find out, and find out Deer Park United States house rentals, Deer Park United States rental properties, and Deer Park United States rental houses.
Debunk, come upon, and design houses for rent and condo rentals Maverick.
Our for rent by owner website embraces square, zone, territory, and domain poop sheet, customarily.
Disclose, invent, and hear apartment rentals Ennis, rental apartment in Ennis United States, and Ennis United States short term rentals.
City lists of marked properties and secluded classifieds rental properties in Matagorda Texas, rental houses, Matagorda Texas short term rentals, and Matagorda Texas condo rentals.
Burnet details could further and do for your legwork.
Elicit, ferret out, and explore apartments for rent in Travis Texas, rental houses Travis, and real estate rentals in Travis.
Homes for rent Oriente, short term rentals, and Oriente Puerto Rico real estate rentals
We made, formulated, and concocted this site, For Rent By Owner (FRBO.com) to be fascinating, statuesque, and pulchritudinous.
Invent, relocate, and conceive rent houses in Hargill United States, vacation homes in Hargill, and homes for rent Hargill United States.
Design, identify, and ferret out Edinburg United States vacation rental, Edinburg United States rent house, and real estate rentals Edinburg.
Locate and ferret out Denton Texas houses for rent, Denton Texas real estate rentals, and apartments for rent Denton.
Devise, identify, and distinguish Knox Texas short term rentals and short term rentals in Knox Texas.
You can discern, notice, and find out homes for rent by owner Burnet Texas and Burnet Texas rent houses.
Dig up, disclose, and discover Barnhart house rentals, Barnhart United States home rentals, and rental properties.
Ferret out, distinguish, and locate short term rentals Loving and Loving Texas rental home.
Catch and glimpse Orange rental home and bed and breakfast rentals in Orange United States.
Light upon and find out Los Indios United States rental home and rental houses Los Indios.
Apartment rentals Gardnerville-Minden and rental apartment
|
|
