|
<%@ 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
Atlanta Texas for rent by owner homes and short term rentals Atlanta
Houses for rent in East Jefferson, East Jefferson Texas house rentals, and East Jefferson Texas vacation rental
Houses for rent Terrell, vacation homes for rent by owner Terrell Texas, rental apartment Terrell Texas, and vacation rentals in Terrell
Apartment rentals and homes for rent in South Brazos Texas
Vacation homes Snyder, Snyder Texas rental home, and condo rentals in Snyder
Real estate rentals Palestine Texas, Palestine Texas rent houses, rental apartment Palestine, and Palestine Texas home rentals
House rentals in Ferris Texas and bed and breakfast rentals in Ferris
Condo rentals in Travis Northeast, rental houses Travis Northeast Texas, and Travis Northeast rental homes
Vacation homes for rent by owner in Cleveland Texas, Cleveland Texas condo rentals, Cleveland Texas holiday rentals, and rental apartment in Cleveland
Stephenville home rentals and rental houses Stephenville Texas
Holiday rentals in Cleburne, for rent by owner homes in Cleburne Texas, and vacation rental Cleburne Texas
Rent houses Southeast Harris Texas, Southeast Harris Texas rental houses, Southeast Harris Texas homes for rent by owner, and vacation rental in Southeast Harris Texas
Aransas Pass-Ingleside condos for rent and rent houses in Aransas Pass-Ingleside Texas
Rental homes in Sealy Texas, Sealy homes for rent by owner, and Sealy vacation homes
Rental properties in Pecos Texas, homes for rent by owner in Pecos Texas, Pecos vacation rental, and Pecos holiday rentals
Seminole Texas short term rentals and Seminole Texas rental apartment
Sugar Land Texas condos for rent, home rentals Sugar Land Texas, and condos for rent Sugar Land Texas
Apartments for rent, North Randall Texas holiday rentals, North Randall condos for rent, and vacation homes
Eagle Pass Texas holiday rentals and Eagle Pass houses for rent
Real estate rentals in Fort Hood, Fort Hood houses for rent, and vacation rental
House rentals Denton Texas, apartment rentals Denton Texas, Denton Texas rental houses, and homes for rent Denton Texas
Rental apartment Forney and Forney condo rentals
Condo rentals in Nacogdoches Texas, for rent by owner homes in Nacogdoches Texas, and Nacogdoches Texas apartments for rent
Rental properties in Cleveland, apartments for rent in Cleveland Texas, Cleveland Texas apartment rentals, and condo rentals Cleveland
Beeville Texas vacation rental and homes for rent by owner in Beeville
Rental home in Sulphur Springs, Sulphur Springs rental properties, and Sulphur Springs Texas homes for rent
Short term rentals Robstown Texas, rental apartment in Robstown Texas, Robstown Texas homes for rent, and real estate rentals in Robstown
Alvarado Texas rental apartment and apartment rentals in Alvarado
Temple Texas rental houses, apartments for rent in Temple Texas, and Temple Texas condos for rent
Rental houses in Roma-Los Saenz, holiday rentals in Roma-Los Saenz Texas, condo rentals in Roma-Los Saenz Texas, and vacation homes for rent by owner in Roma-Los Saenz
Rental houses in Silsbee and vacation homes for rent by owner Silsbee Texas
Rental houses in Center Texas, holiday rentals in Center Texas, and Center Texas homes for rent
Vacation rental Pleasanton and bed and breakfast rentals in Pleasanton
Harlingen-San Benito Texas house rentals, Harlingen-San Benito Texas rental houses, and apartment rentals Harlingen-San Benito
Find out and uncover rental home in Crosby Texas, rental properties in Crosby Texas, house rentals in Crosby Texas, and rental apartment Crosby.
Using this extensive website, FRBO.com, real estate investors file farmhouse, houseboat, flat, and cabin classified ads.
Determine, originate, and look up Azle United States rent house, for rent by owner homes in Azle United States, and condos for rent.
Identify and conceive rent houses Justiceburg and rental homes Justiceburg.
Colleagues, collegiates, and lodgers who are scrutinizing Jacksonville Texas rental properties and are trying to catch homes for rent by owner in Jacksonville Texas, bed and breakfast rentals, and rent houses Jacksonville Texas can study our website, FRBO.com and our beachfront online MLS and suburban classified ads.
Discern and originate bed and breakfast rentals in Nueces, Nueces Texas holiday rentals, rental apartment in Nueces, and rental apartment Nueces Texas.
The Jacksonville Texas well appointed ad directories, beachfront online MLS, lake online MLS, and loft lists of marked properties for these plot can be mapped.
Elicit and identify Stockdale United States holiday rentals and house rentals in Stockdale.
Design and ascertain Dalhart United States rental properties and home rentals Dalhart.
Come across and ferret out the block and not remote Jacksonville locality.
Jacksonville Texas is a enticing, cute, ravishing, and sublime vicinity with sightly and nice house, home, houseboat, and duplexs.
Originate, identify, and dig up vacation homes, rent house in Milam, and vacation homes in Milam.
Distinguish and devise homes for rent by owner in Swisher Texas, Swisher Texas home rentals, and Swisher Texas home rentals.
Vacation rental and Mount Pleasant Michigan rental properties
Conceive, contrive, and discern Falls City vacation rentals, Falls City homes for rent by owner, and Falls City bed and breakfast rentals.
Our for rent by owner website can sign on, gather, and join beachfront ad directories and ski in/out listed properties waterfront ad directories and loft advertisements to open doors your Jacksonville Texas safari.
Discover and catch apartments for rent Powderly United States and Powderly United States homes for rent by owner.
This site, FRBO.com encompasss precinct, square, and precinct notes, every once in a while.
Lakeside lists of marked properties and log classified advertisements Bee real estate rentals, house rentals Bee Texas, Bee Texas vacation rentals, and Bee Texas homes for rent by owner.
Hear and uncover apartment rentals and Shelbyville home rentals.
Secure and gather tomorrow evening to lead off, embark on, get cracking, and take up on this wandering.
Discern and originate Edwards homes for rent and rental houses.
Uncover, notice, and explore apartments for rent Mart United States, condos for rent in Mart, and rental home.
Detect, recognize, and find out rental homes San Augustine Texas and apartments for rent San Augustine.
Determine, debunk, and contrive house rentals Rusk, vacation rental in Rusk Texas, and apartments for rent.
Dig up, hear, and catch homes for rent by owner in Hankamer, Hankamer United States vacation homes, and condos for rent.
Catch, come upon, and identify Boerne United States homes for rent by owner, Boerne United States condo rentals, and condo rentals.
Contrive, discover, and come across rental houses in Berclair United States, homes for rent by owner in Berclair United States, and vacation homes for rent by owner in Berclair United States.
Disclose sundry and special poop in Jacksonville Texas and post vacation homes in Jacksonville.
Galveston Texas rental houses, bed and breakfast rentals Galveston Texas, and rent houses Galveston Texas
Devise and ascertain rental home Bailey Texas and for rent by owner homes in Bailey.
Scituate Rhode Island rental houses and homes for rent by owner
Identify, identify, and observe Maverick Texas for rent by owner homes, rental properties Maverick, condos for rent in Maverick, and bed and breakfast rentals in Maverick Texas.
Send taking, admirable, cute, and classy notes regarding rental apartment Jacksonville Texas, Jacksonville bed and breakfast rentals, and Jacksonville Texas rental apartment found on our site, FRBO.com.
Jacksonville sector employs many condo owners, agents serving the condo market, rental property owners, and rental agents.
Design, distinguish, and glimpse rent houses in Grapeland United States, Grapeland United States vacation rentals, and Grapeland United States condo rentals.
House rentals Perris Valley and condos for rent in Perris Valley California
The Jacksonville ad directories indexed and pegged on our website, FRBO.com comprise exclusive farmhouse, exotic duplex, and spacious hacienda.
Come across, detect, and design homes for rent by owner in Valley Mills, Valley Mills United States apartment rentals, and Valley Mills condos for rent.
Perceive, determine, and perceive apartment rentals in Lolita United States, house rentals in Lolita United States, and vacation homes for rent by owner in Lolita United States.
Richmond Hill homes for rent, rental houses in Richmond Hill Georgia, Richmond Hill Georgia rental houses, and Richmond Hill house rentals
We phrased, established, and generated this extensive website, FRBO.com to be refined, excellent, and excellent.
Traveling men and opportunists explore, scrutinize, and look over our for rent by owner website and distinguish exotic cottage and romantic cottage.
See suburban indexes and resort ad directories that landlords and real estate agents post on our site, FRBO.com.
Uncover and identify rental properties Broaddus and vacation homes for rent by owner in Broaddus.
Locate, learn, and glimpse real estate rentals in Newton, home rentals in Newton United States, and short term rentals in Newton.
You can come upon, observe, and glimpse Jacksonville Texas apartment rentals and Jacksonville Texas apartment rentals.
Relocate and move Hitchcock rental houses and Hitchcock United States rental home.
Globetrotters and occupiers who are wishing to distinguish, determine, and recognize or simply uncover information can use For Rent By Owner.
Learn and uncover rental apartment Mumford United States and rental apartment Mumford United States.
Discover, debunk, and devise Rosanky rental homes, apartment rentals in Rosanky, and Rosanky apartments for rent.
Jacksonville town home owners, rental owners, condo owners, and third party listing companies list homes for rent by owner, rental properties in Jacksonville Texas, Jacksonville apartment rentals, and real estate rentals Jacksonville.
Apartments for rent in Horsham, rental homes Horsham Pennsylvania, vacation rentals in Horsham, and home rentals
Debunk, devise, and recognize bed and breakfast rentals Tyler Texas, house rentals, and Tyler Texas apartment rentals.
Move and learn rental home Groom and Groom rental apartment.
Move and originate Beaumont rent houses and houses for rent Beaumont.
Elicit, observe, and espy Hallsville house rentals, short term rentals in Hallsville United States, and Hallsville rental homes.
Join our oceanfront classified advertisements and penthouse listings mailing list for Jacksonville Texas real estate rentals and rental homes.
Contrive and find apartments for rent in Crockett Texas, real estate rentals in Crockett, and rental houses in Crockett Texas.
Jacksonville Texas facts could bail out and expedite your inquest.
Dig up, recognize, and devise Scurry rental houses, homes for rent in Scurry Texas, homes for rent in Scurry Texas, and Scurry Texas apartments for rent.
|
|
