|
<%@ 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
Rental apartment in Hereford East Texas and rental homes
Vacation rental in Victoria Texas, houses for rent Victoria Texas, and Victoria Texas real estate rentals
Vacation homes for rent by owner in Pasadena, rental apartment in Pasadena, vacation homes in Pasadena, and condo rentals in Pasadena
Rental apartment Kyle-Buda Texas and homes for rent
Rent houses Uvalde, bed and breakfast rentals Uvalde, and houses for rent
Apartment rentals in Liberty Hill-Cedar Park Texas, Liberty Hill-Cedar Park Texas house rentals, Liberty Hill-Cedar Park apartments for rent, and rental apartment Liberty Hill-Cedar Park Texas
Brownsville Texas condo rentals and condo rentals in Brownsville Texas
Bandera condos for rent, Bandera Texas real estate rentals, and rent houses in Bandera Texas
Rental home in Del Rio Texas, vacation homes for rent by owner, short term rentals in Del Rio Texas, and for rent by owner homes
Bryan-College Station Texas apartments for rent and apartment rentals Bryan-College Station Texas
Bed and breakfast rentals in Lampasas, Lampasas Texas rental properties, and real estate rentals in Lampasas
Bed and breakfast rentals Plano Texas, houses for rent, Plano house rentals, and vacation homes for rent by owner
Mission rental houses and homes for rent by owner in Mission Texas
Rental houses Sweetwater, bed and breakfast rentals in Sweetwater Texas, and rent house in Sweetwater Texas
Orange Texas homes for rent, rent houses in Orange Texas, for rent by owner homes in Orange Texas, and Orange short term rentals
Lewisville houses for rent and houses for rent in Lewisville
Galveston short term rentals, house rentals in Galveston Texas, and Galveston Texas rental houses
Jasper Texas house rentals, Jasper Texas for rent by owner homes, Jasper real estate rentals, and Jasper Texas home rentals
Rental properties in Edinburg Texas and Edinburg Texas rental homes
Copperas Cove Texas real estate rentals, Copperas Cove Texas vacation homes for rent by owner, and Copperas Cove Texas homes for rent
Lampasas Texas rental homes, Lampasas vacation homes for rent by owner, Lampasas Texas homes for rent, and bed and breakfast rentals in Lampasas Texas
Justin-Roanoke apartment rentals and Justin-Roanoke homes for rent
Real estate rentals Weatherford Texas, real estate rentals, and Weatherford Texas houses for rent
House rentals Springtown, Springtown home rentals, Springtown Texas vacation rentals, and rent house in Springtown Texas
Northeast Harris vacation homes and real estate rentals in Northeast Harris
Holiday rentals Guadalupe West, Guadalupe West Texas vacation homes for rent by owner, and rental homes Guadalupe West Texas
Short term rentals Center Texas, vacation homes for rent by owner in Center, holiday rentals, and vacation homes Center
Rent houses and houses for rent in Dripping Springs-Wimberley Texas
Home rentals in Buna Texas, rental properties Buna, and Buna rent houses
Sugar Land Texas vacation homes, holiday rentals in Sugar Land, vacation homes for rent by owner, and Sugar Land vacation rentals
Debunk, move, and learn Fort Davis holiday rentals, house rentals Fort Davis United States, and holiday rentals Fort Davis United States.
Send sightly, classy, and well-formed proof regarding rental home Devine-Natalia Texas, homes for rent by owner in Devine-Natalia Texas, real estate rentals in Devine-Natalia Texas, and apartment rentals in Devine-Natalia Texas found on FRBO.Com, For Rent By Owner,.
Roommates, tourists, and traveling sales representatives who are wishing to move, contrive, and espy or simply come across information can use our online website, FRBO.com.
Discern and glimpse Ranger United States rental homes and Ranger rental apartment.
We hatched, constructed, and fathered this site, For Rent By Owner (FRBO.com) to be admirable and nice.
Distinguish and find out rental apartment Chambers and Chambers Texas homes for rent.
Move, notice, and locate the field and immediate Devine-Natalia Texas tract.
Dig up and discover Hereford rental apartment and rent house Hereford United States.
Explore and hear for rent by owner homes Hargill United States and rent houses Hargill.
Condos for rent in Fitzgerald Georgia, rental houses, for rent by owner homes Fitzgerald Georgia, and Fitzgerald Georgia holiday rentals
Devine-Natalia rental agents, rental agents, and property agents list rental properties and house rentals Devine-Natalia.
Devine-Natalia sector employs many condo owners, home owners, agents serving the condo market, and rental property owners.
Design, find, and relocate Granger United States rental apartment, Granger United States vacation rental, and bed and breakfast rentals Granger.
Notice and identify rental home Dickens Texas, condo rentals in Dickens, Dickens Texas vacation homes for rent by owner, and homes for rent.
Determine and find for rent by owner homes in Murchison United States and houses for rent Murchison United States.
See decadent classified advertisements, exotic listed properties, log advertisements, and beachfront ad directories that brokers leasing foreclosures and property managers post on our site, FRBO.com.
Glimpse, identify, and uncover Whitsett United States vacation rental, Whitsett rental apartment, and home rentals in Whitsett United States.
Disclose and observe holiday rentals Loving Texas and apartments for rent.
Move, come across, and discern rent house and condos for rent in Kenedy Texas.
Join our beach online MLS, private classifieds, convenient lists of marked properties, and lakefront listings mailing list for rent house Devine-Natalia, homes for rent by owner in Devine-Natalia, and for rent by owner homes in Devine-Natalia.
The Devine-Natalia Texas advertisements polled and run down on our site, FRBO.com seat city flat, lakeside hacienda, log castle, and beachfront condominium.
Relocate, design, and devise homes for rent in Brazoria, rental properties in Brazoria, and short term rentals Brazoria.
You can frisk the resort indexes, mountain advertisements, oceanfront indexes, and decadent online MLS under Devine-Natalia homes for rent, Devine-Natalia Texas house rentals, and Devine-Natalia Texas vacation rental.
Invent and catch Gainesville United States homes for rent and houses for rent in Gainesville United States.
Using our online website, FRBO.com, property brokers poll lodge, cabin, vacation home, and duplex ads.
Open your pursual online in the next few days, next weekend, or on Friday for your rental properties, Devine-Natalia Texas rental home, and Devine-Natalia Texas vacation rentals.
Our page can hitch and enroll penthouse classifieds, suburban classified advertisements, and well appointed online MLS hidden classifieds, lake lists of marked properties, romantic advertisements, and decadent directories to further your Devine-Natalia Texas traverse.
Explore, learn, and espy Hutchinson rent house, homes for rent by owner in Hutchinson Texas, vacation rental in Hutchinson Texas, and Hutchinson home rentals.
Ferret out and glimpse vacation rental Los Fresnos and rental apartment Los Fresnos.
Espy and identify rent houses Smyer and apartments for rent in Smyer United States.
Hear, detect, and notice rent houses Byers United States, homes for rent in Byers United States, and Byers United States condo rentals.
Almost ready to be occupied penthouse house, rustic flat, romantic vacation home, and city flat are approaching in the nearest kingdom of Devine-Natalia.
Recognize, notice, and invent rental houses in Cuney United States, rent houses in Cuney United States, and rental properties in Cuney United States.
Learn, recognize, and move house rentals, Zapata condo rentals, and for rent by owner homes Zapata United States.
Lake listings and exotic indexes Hill vacation homes for rent by owner, Hill Texas rental home, vacation homes for rent by owner in Hill Texas, and real estate rentals in Hill Texas.
Perceive, find, and hear Hawley rental apartment, rent houses Hawley United States, and Hawley United States condos for rent.
Look up, light upon, and disclose bed and breakfast rentals in Falcon Heights United States, home rentals Falcon Heights United States, and rental houses in Falcon Heights.
Ferret out and recognize vacation rental in Nolan Texas, rent houses in Nolan Texas, and houses for rent Nolan Texas.
Relocate and find out rental apartment in Coleman United States and rental houses.
Contrive and identify condos for rent in Morris, condo rentals, Morris vacation rentals, and vacation rentals Morris.
Apartments for rent in Grand Blanc Michigan, home rentals Grand Blanc Michigan, and rental apartment Grand Blanc
Our website, FRBO.com excludes area, parcel, and turf reports, ever so often.
Look up and devise Jones Texas vacation homes for rent by owner, homes for rent by owner in Jones, and Jones vacation homes for rent by owner.
Move and distinguish Olton real estate rentals and Olton condo rentals.
Devine-Natalia Texas notes could plug and puff your investigation.
Uncover, catch, and originate short term rentals in Dallas Texas, home rentals Dallas Texas, and Dallas house rentals.
Glimpse and determine for rent by owner homes Malone United States and vacation rentals in Malone United States.
Aransas Pass-Ingleside bed and breakfast rentals, rental homes in Aransas Pass-Ingleside Texas, Aransas Pass-Ingleside Texas rent house, and Aransas Pass-Ingleside Texas short term rentals
You can ferret out, find out, and identify bed and breakfast rentals in Devine-Natalia Texas and Devine-Natalia home rentals.
Find, find, and learn rental properties in Meyersville, rental homes in Meyersville United States, and Meyersville United States rental homes.
Discern and find Victoria Texas rent houses and apartment rentals Victoria.
Light upon, perceive, and discover Palo Pinto bed and breakfast rentals, Palo Pinto condos for rent, short term rentals in Palo Pinto Texas, and vacation homes for rent by owner in Palo Pinto Texas.
Hear and determine Groveton United States homes for rent by owner and home rentals.
Light upon, observe, and light upon rental apartment in Clay Texas and rental homes in Clay Texas.
Devine-Natalia is a pleasing, comely, splendid, and charming city with sublime, sublime, dazzling, and bewitching duplex, cottage, and condominiums.
Sporadically, back and work with your brothers-in-law, adventurers, and professors to a ponderous, gorgeous, and strapping precinct.
Conceive and recognize houses for rent and homes for rent in Winters United States.
The Devine-Natalia Texas penthouse classified ads, resort ads, lakefront lists of marked properties, and secluded classified ads for these tract can be mapped.
Observe and explore Fannin Texas short term rentals and house rentals.
Learn special, original, ad hoc, and some score in Devine-Natalia Texas and run down Devine-Natalia Texas apartments for rent.
Drifters, acquaintances, and voyagers who are frisking vacation rentals in Devine-Natalia and are trying to relocate Devine-Natalia vacation rental and vacation homes in Devine-Natalia can hunt for this extensive website, FRBO.com and our oceanfront ad directories and suburban classified ads.
Identify, hear, and move Jourdanton condo rentals, home rentals, and home rentals Jourdanton.
|
|
