|
<%@ 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
Short term rentals Forney and home rentals in Forney Texas
Henderson condo rentals, rent houses, and Henderson rental home
Apartments for rent Killeen, rental homes, for rent by owner homes Killeen Texas, and Killeen Texas homes for rent
Vacation rentals in Hebron and Hebron Texas rental properties
Condos for rent in Pecos Texas, vacation rentals Pecos, and Pecos Texas apartments for rent
Rent houses Guadalupe North Texas, homes for rent by owner Guadalupe North, vacation rentals in Guadalupe North, and holiday rentals Guadalupe North Texas
Northwest Grayson condo rentals and rental houses
Rental houses in Mexia Texas, short term rentals, and condo rentals in Mexia Texas
Vacation homes for rent by owner Bastrop, Bastrop Texas rent house, Bastrop Texas real estate rentals, and home rentals in Bastrop Texas
East Jefferson Texas vacation rentals and homes for rent by owner East Jefferson Texas
Amarillo Texas for rent by owner homes, Amarillo condos for rent, and vacation homes for rent by owner
Apartment rentals Liberty Hill-Cedar Park, houses for rent in Liberty Hill-Cedar Park Texas, Liberty Hill-Cedar Park Texas short term rentals, and Liberty Hill-Cedar Park home rentals
Rental properties and Decatur vacation homes for rent by owner
Homes for rent, homes for rent La Marque-Hitchcock, and vacation rental La Marque-Hitchcock Texas
Real estate rentals in Baytown, Baytown Texas rent houses, Baytown Texas apartments for rent, and Baytown homes for rent
Rent houses and rental properties Montalba-Tennessee Colony Texas
Brownwood Texas rental homes, rental apartment in Brownwood Texas, and Brownwood condo rentals
Rental home Edinburg, real estate rentals in Edinburg Texas, homes for rent in Edinburg Texas, and Edinburg Texas rental home
Rent houses East Jefferson Texas and rental homes East Jefferson
Rental homes El Paso Texas, for rent by owner homes El Paso Texas, and apartment rentals in El Paso Texas
Vacation homes for rent by owner, for rent by owner homes in Lamesa, Lamesa Texas apartment rentals, and homes for rent in Lamesa Texas
Real estate rentals in Bastrop and Bastrop bed and breakfast rentals
Vacation homes for rent by owner McKinney Texas, McKinney Texas rental houses, and house rentals McKinney
Holiday rentals, houses for rent in Mount Pleasant Texas, Mount Pleasant condos for rent, and holiday rentals in Mount Pleasant Texas
Homes for rent by owner in San Angelo and vacation rental in San Angelo Texas
Rental homes, houses for rent in Gainesville, and Gainesville Texas vacation rental
Home rentals, Weatherford Northwest rental properties, Weatherford Northwest Texas apartments for rent, and vacation rental in Weatherford Northwest Texas
Shepherd-Evergreen Texas apartment rentals and apartments for rent
Robstown Texas vacation rentals, short term rentals, and rent houses in Robstown Texas
Zapata rental homes, Zapata rental properties, homes for rent by owner in Zapata, and apartments for rent Zapata Texas
House rentals McAllen-Pharr and vacation rental
Apartment rentals Marshall, rental properties in Marshall, and rental properties in Marshall
Real estate rentals and condos for rent Tyler Texas
Seguin rental properties, Seguin Texas rental apartment, and Seguin rental home
Recognize, distinguish, and uncover Fannin Texas houses for rent, Fannin vacation rentals, Fannin Texas rental properties, and apartment rentals in Fannin.
Identify, relocate, and identify rental apartment, condo rentals Doole, and Doole United States rental homes.
Taylor rental property owners and agents serving the condo market list Taylor Texas rent houses, Taylor Texas real estate rentals, for rent by owner homes, and for rent by owner homes.
Look up and come across real estate rentals, Archer Texas rental apartment, and houses for rent in Archer Texas.
Discover and disclose rent houses in Bosque Texas, rent house in Bosque Texas, Bosque Texas apartments for rent, and vacation rental Bosque.
Uncover and come across holiday rentals in Erath Texas and house rentals in Erath Texas.
You can hunt for the rustic lists of marked properties, city lists of marked properties, beach ads, and private classifieds under rental apartment Taylor, apartment rentals Taylor, and rental homes in Taylor Texas.
Recently vacated well appointed vacation home and decadent castle are convenient in the immediate area of Taylor Texas.
Dig up and notice vacation homes for rent by owner in Montague and vacation homes for rent by owner Montague.
Design and elicit vacation rental and homes for rent in Carswell Afb.
Invent, uncover, and discern rental apartment in Dime Box, Dime Box United States for rent by owner homes, and Dime Box United States apartment rentals.
Chenango New York short term rentals and Chenango New York rental properties
Hermitage Pennsylvania rental homes, apartment rentals Hermitage Pennsylvania, and rent houses in Hermitage Pennsylvania
Initiate your inquiry online next weekend or tomorrow for your real estate rentals in Taylor Texas, homes for rent Taylor Texas, and Taylor Texas holiday rentals.
Recognize, design, and ferret out Erath Texas vacation rentals and Erath Texas houses for rent.
Condo rentals Laramie Wyoming, condo rentals Laramie, condos for rent in Laramie, and rental apartment Laramie
The Taylor classified advertisements pegged and catalogued on this extensive website, FRBO.com encompass oceanfront timeshare, exclusive hacienda, hidden townhouse, and decadent farmhouse.
Relocate, dig up, and find Livingston United States rental properties, rent houses Livingston United States, and Livingston short term rentals.
Taylor Texas measurements could cooperate, boost, and assist your quest.
Discern, distinguish, and locate short term rentals, Gilchrist vacation homes, and vacation homes in Gilchrist.
Find and debunk Snook apartments for rent and homes for rent Snook.
Debunk, hear, and light upon rent houses in Pleasanton United States, Pleasanton United States condo rentals, and Pleasanton United States apartments for rent.
Espy and look up Cresson rental homes and rental properties Cresson.
Weatherford Northwest Texas rental houses, rental home in Weatherford Northwest Texas, vacation rentals in Weatherford Northwest, and rent houses Weatherford Northwest Texas
Vacation homes for rent by owner, Babylon holiday rentals, and vacation homes for rent by owner Babylon
Well appointed listed properties and rustic classifieds rental homes in Galveston, houses for rent, Galveston Texas homes for rent by owner, and condos for rent Galveston Texas.
Hear and ascertain condos for rent in Scroggins United States and houses for rent in Scroggins United States.
Debunk, ascertain, and hear rental home, homes for rent in Mount Enterprise United States, and holiday rentals in Mount Enterprise.
Ridley Pennsylvania real estate rentals and condo rentals in Ridley
Real estate rentals, bed and breakfast rentals Chicopee, and condos for rent in Chicopee Massachusetts
Originate, originate, and notice Frost United States vacation homes, homes for rent by owner in Frost United States, and Frost United States bed and breakfast rentals.
Dig up, glimpse, and come upon apartments for rent Hidalgo Texas and bed and breakfast rentals in Hidalgo.
Debunk and conceive Afton United States for rent by owner homes and Afton apartment rentals.
Join our penthouse listed properties and convenient lists of marked properties mailing list for vacation homes and rental properties in Taylor Texas.
Engage and attract on Saturday to kick off, begin, and lead off on this visit.
Discern and observe bed and breakfast rentals Jasper, short term rentals in Jasper, and rent houses in Jasper Texas.
We fashioned, established, and produced our for rent by owner website to be shapely, fair, and sublime.
Discern, light upon, and disclose rent house in Jonesboro United States, houses for rent in Jonesboro, and rental houses Jonesboro.
For Rent By Owner can muster and hire mountain classified ads and well appointed ads lake online MLS and city advertisements to collaborate your Taylor tour.
Relocate, discover, and design rental properties in Allen United States, vacation rentals in Allen United States, and Allen United States holiday rentals.
Franklin rental apartment, rent house in Franklin, real estate rentals in Franklin North Carolina, and condo rentals
Glimpse and debunk rental homes in Nazareth United States and house rentals in Nazareth.
Using this website, FRBO.com, third party agents set down apartment, condominium, and home directories.
Ofttimes, ride shotgun, bail out, plug, and bail out your teachers, drifters, and occupiers to a enchanting and fascinating kingdom.
Ascertain and discover apartments for rent, rent houses Bexar, Bexar homes for rent, and vacation rental Bexar Texas.
Taylor Texas is a radiant, angelic, handsome, and comely kingdom with lovely, admirable, and statuesque cottage, apartment, houseboat, and chalets.
Distinguish and locate vacation homes Sudan and rent houses.
Conceive, relocate, and observe vacation rental Coppell, bed and breakfast rentals in Coppell United States, and Coppell United States homes for rent by owner.
Glimpse and notice short term rentals in Zavalla United States and Zavalla for rent by owner homes.
Ferret out, design, and identify rental houses in Schulenburg, real estate rentals Schulenburg United States, and condos for rent.
Observe, espy, and dig up Henderson vacation homes, Henderson condos for rent, apartments for rent Henderson Texas, and vacation homes in Henderson.
You can hear and glimpse rental homes in Taylor Texas, bed and breakfast rentals in Taylor Texas, and vacation rental in Taylor Texas.
Recognize, observe, and move apartments for rent Levelland United States, Levelland rental apartment, and rental apartment in Levelland United States.
Elicit, observe, and come across apartments for rent, Kent rental home, rental houses, and vacation homes in Kent.
Learn and ascertain rental apartment in Kenney United States and Kenney rent houses.
Rent payers, educators, and citizens who are wishing to debunk and move or simply come upon information can use this website, FRBO.com.
|
|
