Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:12:59.770' ,`MLSNumber` = '51001414' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.497281' ,`Longitude` = '-95.384117' ,`PhotoCount` = '20' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Martin Ridge' ,`StreetNumber` = '4027' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 4027 Martin Ridge Drive located in the community of \r\nDel Bello Lakes and zoned to Alvin ISD. The Santana floorplan features 4 bedrooms, 3 full baths, and an attached 2 car garage. This home includes a study, a kitchen that is open to the family room and a spacious master retreat. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is October 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Del Bello Lakes Section 5, Block 2, Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7008' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649817' WHERE `Matrix_Unique_ID` = '209029358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:12:38.367' ,`MLSNumber` = '97140292' ,`ListAgentFullName` = 'Alejandro Soules-Lara' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145080' ,`Longitude` = '-95.491910' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood' ,`StreetNumber` = '3323' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY AND COMPLETELY RENOVATED, READY TO MOVE-IN SPACIOUS HOME located on a corner lot with 2 driveways in a comfortable neighborhood in The Woodlands minutes away from The Woodlands Mall, Market St, and the Mitchell Nature Preserve where your family will enjoy miles of hiking and biking. Situated in the renowned Conroe ISD with “A” rated schools like Glen Loch Elementary. Amenities include a pool area with playground. The entire interior and exterior are newly painted with a new roof, gutters, sprinkler system and HVAC system. The 1st floor offers a large master bedroom with adjoining bath, two extra bedrooms, a dining room, breakfast room with bay window, and a large living room. The new section offers a huge tiled game room with high ceilings and gas connections for a new kitchen, a 2nd master bedroom with adjoining bathroom and bay window, a study/ office with 1/2 bath and balcony with French doors. Perfect for a mother-in-law’s apartment. Appliances included. Never flooded!' ,`Acres` = '0.2135' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 03, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Ridge 03' ,`TaxAmount` = '4685' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649817' WHERE `Matrix_Unique_ID` = '209840329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:02:34.447' ,`MLSNumber` = '17776611' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465138' ,`Longitude` = '-95.316741' ,`PhotoCount` = '26' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Mountain' ,`StreetNumber` = '6306' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to the beautiful Kerrville Plan in Del Bello Lakes community and zoned to Alvin ISD. This stunning home features 3 bedrooms, 2.5 baths, and an attached 3-car tandem garage. Beautiful kitchen features light quartz counters, light cabinets, and stainless-steel appliances. As you look out into the living room you see a breath taking coffered ceiling, beautiful wood flooring and large windows that provide an abundance amount of natural light. Come unwind after a long day in the primary suite over looking the amazing views. The primary suite features an oversized walk-in shower, dual vanities, separate garden tub, and spacious walk-in closet. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Del Bello Lakes Section 5, Block 2, Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6946' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649817' WHERE `Matrix_Unique_ID` = '210293805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:00:54.390' ,`MLSNumber` = '36149615' ,`ListAgentFullName` = 'William Jenkins' ,`ListOfficeName` = 'The Hatmaker Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.285253' ,`Longitude` = '-94.823824' ,`PhotoCount` = '32' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O' ,`StreetNumber` = '5216' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully restored and renovated 1939 cottage. Natural light abounds throughout the house with tons of windows and glass storm doors. 3 bedrooms, with no shared walls, provide lots of space and privacy for family and friends, or for home office or craft rooms. Original hardwoods throughout most of the house keep with the historic charm while updated kitchen and bathrooms keep up with the times! The kitchen features IKEA cabinetry with soft close doors and drawers, all with a 25 year warranty. There is plenty of off street parking with a drive through drive way that goes from Ave O to the alley. Also, there is plenty of room out back for a garage or carport. The front in beautifully landscaped with a mature plumeria in bloom!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 19 & 20 BLK 77 DENVER RESURVEY' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '2893' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669649818' WHERE `Matrix_Unique_ID` = '211316483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:50:21.287' ,`MLSNumber` = '70300944' ,`ListAgentFullName` = 'Cindy Price' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689807' ,`Longitude` = '-95.351498' ,`PhotoCount` = '27' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'New York' ,`StreetNumber` = '6723' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS THE ONE! Your chance is here to own a fully rebuilt home in Grand Park worthy of a TV transformation show. This 1950s home has been transformed into a modern gem perfectly designed for the 2022 buyer. ALL NEW - completed in July 2022: ROOF, HVAC, ELECTRICAL, PLUMBING, FLOORING, WINDOWS and APPLIANCES. The floor plan has been revamped to allow for an open concept. The kitchen is a chef\'s dream with an oversized quartz countertop island, new cabinets, sink, faucet & open shelving. The primary bedroom was added with a large walk-in closet & full bath with new toilet, vanity, mirror, & walk-in shower. Two secondary bedrooms share a newly remodeled bathroom with all new flooring, vanity, mirror and shower. Home has an attached carport. Property includes a detached building that can be used for storage, a business or finished to be additional living space. No HOA, No MUD and Low Taxes!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = 'IEC Design House LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 14 GRAND PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Park' ,`TaxAmount` = '1539' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649818' WHERE `Matrix_Unique_ID` = '211634786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:08:48.587' ,`MLSNumber` = '19785828' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747501' ,`Longitude` = '-95.785278' ,`PhotoCount` = '34' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Knoll' ,`StreetNumber` = '2523' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Yard of the Month! No back neighbors! Completely updated 5 bedroom zoned to Cinco Ranch Junior & High. Master bed-bath suite plus half-bath downstairs, with 4 beds and 2 full baths up with flexible loft area. Private pool and hot tub with wireless solar LED lighting that brings the backyard to full-color life each evening! Quartz island kitchen with herringbone backsplash, and baths ALL recently remodeled; custom fireplace in living room. Upstairs full laundry room PLUS combo washer/dryer unit in downstairs master closet; all can stay. Water resistant laminate flooring throughout, except high grade carpet on stairs, and tile in baths and laundry. New AC unit 2022 (other unit is 2018). Water heater 2022. All duct work and dryer vents cleaned. Detached garage, backs to Willow Fork bayou trail. Walk or bike the trails a short distance, 6 mins, to junior or high school quickly and safely with no street traffic. Please note: Live Camera Surveillance.' ,`Acres` = '0.194' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 4, BLOCK 5, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '594' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Falcon Ranch' ,`TaxAmount` = '9630' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649818' WHERE `Matrix_Unique_ID` = '211973447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:49:36.797' ,`MLSNumber` = '90357295' ,`ListAgentFullName` = 'Elizabeth Watkins' ,`ListOfficeName` = 'The Watkins Group Realty' ,`SellingAgentFullName` = 'Bryan Beene' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.875511' ,`Longitude` = '-95.467700' ,`PhotoCount` = '43' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bent Bough' ,`StreetNumber` = '5419' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home is located on a tree lined cul de sac in Inwood Forest. Very lovely home is just waiting for your updates. A traditional one story with a separate level fourth bedroom and en suite bath with a private stairway entrance off den. Extra large lot, which backs onto green space. Minutes from downtown Houston, IAH Airport, Minute Maid, NRG, Toyota and other stadiums. Seller does not have survey, buyer to purchase if needed. Home is not in flood zone. *Only offers submitted on TREC 1-4 Residential Contract will be responded to.' ,`Acres` = '0.2094' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 INWOOD FOREST SEC 5' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level' ,`Subdivision` = 'Inwood Forest' ,`TaxAmount` = '4617' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649818' WHERE `Matrix_Unique_ID` = '211973794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:33:23.803' ,`MLSNumber` = '15272695' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057707' ,`Longitude` = '-95.128146' ,`PhotoCount` = '34' ,`PostalCode` = '77336' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Thomas' ,`StreetNumber` = '27603' ,`StreetSuffix` = 'Road' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Throw your fishing rod from comfort of your back deck into the private lake while living in this SINGLE FAMILY (not mobile) HOME on 2.7 UNRESTRICTED acres. 6+ FT WOOD FENCE ALL AROUND THE PROPERTY. Home was taken down to the studs elevated from it\'s previous elevation, remodeled with the tastiest of finishes. Home features 2 primary suites with double vanities, all bathroom vanities throughout the house boasting BRIZO faucets, SIGNATURE HARDWARE Shower faucets, light fixtures from designer brands. New electrical wiring, plumbing, roof, hardie siding, 5 ton Carrier HVAC, water heater, energy efficient double pane windows, Luxury Vinyl plank floors Porcelain & Quartz kitchen counters & backsplash, shaker cabinetry, stainless steel appliances package, ship lap accent walls in all bathrooms and more. Inquire about list of upgrades.2 car garage plus huge man cave that can be converted to an apartment.6 car driveway+RV parking. APPRAISAL at 556K. SELLER CAN CONTRIBUTE TO LOWER INTEREST RATE' ,`Acres` = '2.7' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 96 PERPETUAL OIL CO' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '115680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Perpetual Oil Co' ,`TaxAmount` = '' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649819' WHERE `Matrix_Unique_ID` = '212108984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:21:05.230' ,`MLSNumber` = '53549129' ,`ListAgentFullName` = 'Knakita Jones' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Jennifer Austin' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.889447' ,`Longitude` = '-95.420543' ,`PhotoCount` = '0' ,`PostalCode` = '77088' ,`RoomCount` = '4' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Deer Trail' ,`StreetNumber` = '9007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained 3 bedroom, 2 bathroom home ready for new owner. Nice corner lot, beautiful landscape, large back yard.' ,`Acres` = '0.2193' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1054 BLK 40 HIDDEN VALLEY WEST SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'STOVALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Valley West Sec 04' ,`TaxAmount` = '3711' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649819' WHERE `Matrix_Unique_ID` = '212487780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:44:25.880' ,`MLSNumber` = '5490869' ,`ListAgentFullName` = 'Rosa Borbolla' ,`ListOfficeName` = '4 Rivers Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117863' ,`Longitude` = '-95.515618' ,`PhotoCount` = '19' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Willowcrest' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great home is in the wooded community of Northampton Estates. Minutes from TX99, The Woodlands, Exxon, and HP. Fall for the lifestyle, pools, ponds, park and most of all walking distance to Willow Creek Golf Course. Entire plumbing has been replaced with PEX Pipe, New roof 2021, new water heater. Update this home to be yours.' ,`Acres` = '0.2525' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 NORTHHAMPTON ESTATES PH 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northampton Estates Ph 01' ,`TaxAmount` = '6769' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649819' WHERE `Matrix_Unique_ID` = '212709968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:36:09.580' ,`MLSNumber` = '64085529' ,`ListAgentFullName` = 'Tiffany Fuller' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999172' ,`Longitude` = '-95.597614' ,`PhotoCount` = '33' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '519500.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Saint Honore' ,`StreetNumber` = '15426' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beauty tucked away in a gated community lined with gorgeous oak trees all within an A+ rated Tomball schools. Beautiful curb appeal with architectural features from the brick, arches, shutters, and tutor style coming off the roof line. Upon entrance into the home you\'ll see high ceilings, great natural light and a grand staircase, which has a side access off the kitchen as well. Lots of custom built shelving and cabinets located in the living room, office, game room, and media room! The media room could be used as an additional playroom, office, or sitting room. There is even a sun room off the breakfast room. Wood floors through out the downstairs, tile in the wet areas, and brand new carpet on the stairs and second floor. ENTIRE HOUSE UPDATED WITH painted INTERIOR WALLS! Grand kitchen perfect for entertaining with a double oven and gas range. Nicely landscaped. Walking distance to elementary school from back gate neighborhood access.' ,`Acres` = '0.259' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 VILLAGGIO SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11282' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villaggio' ,`TaxAmount` = '9747' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649819' WHERE `Matrix_Unique_ID` = '212985582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:31:45.387' ,`MLSNumber` = '45638201' ,`ListAgentFullName` = 'Theresa Scheib' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235160' ,`Longitude` = '-95.150180' ,`PhotoCount` = '43' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Splenwood' ,`StreetNumber` = '14392' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED! 2 HOMES FOR THE PRICE OF ONE! Spacious 3/2 home (approx. 1344 sq ft) & a 1 bedrm GUEST HOUSE -approx 800 sq ft. per previous seller. Recently remodeled & offers a covered RV parking area w/electric hookup & 3+ car carport most of it covered on 3 sides, 20x15 workshop & huge covered back patio. New luxury vinyl floors thru-out, brand new A/C system including ductwork installed 8-10-22, newly painted inside top to bottom w/new baseboards, several new ceiling fans & new counters in kitchen. Refrigerator is included as well as washer & dryer in main home. The guest home has a 20x15 living room, kitchen w/gourmet range, breakfast room & large primary bedroom. Great street & neighbors & only about a mile to I-59. Close to 99 & Kingwood & all kinds of shopping. Per previous seller/original owner old home was torn down & this home was built in 1995 were the only ones to live in the home.' ,`Acres` = '0.2638' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'SPLENWOOD, BLOCK 2, LOT 46, ACRES 0.260' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splenwood' ,`TaxAmount` = '1395' ,`TaxRate` = '2.4206' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649820' WHERE `Matrix_Unique_ID` = '213076913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:43:01.800' ,`MLSNumber` = '89962858' ,`ListAgentFullName` = 'Kathy Phelan-Morales' ,`ListOfficeName` = 'Brokerology Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155389' ,`Longitude` = '-95.674455' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '14' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Mill Creek' ,`StreetNumber` = '518' ,`StreetSuffix` = 'Road' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT!Stunning luxury LAKEFRONT home in prestigious Gated Community Woodtrace!Boasting 5,472sqft,5 beds 4.5 baths+study,open concept Formal Dining area,Family Rm w/built-ins,fireplace,wall of windows w/Lake view,Game Rm&Media Rm w/110\' Diagonal Projector Screen& Sound System.Secluded In-law like Suite on first floor.Step inside the foyer to be greeted by wrought iron staircase and enchanting Courtyard w/Fireplace.1st flr-Owner’s retreat has sitting area w/fireplace&lakeview.Boutique style closet.Spa-like bath w/dual granite vanities,jetted tub,luxurious walk-through shower w/dual shower heads,bench,entrance shower heaters.Chefs kitchen boasts oversized island w/bar seating lux appliances,granite counters&captivating backsplash,butlers pantry.Dry Bar w/Sonic Ice Maker.Breakfast area w/lake view,access to outdoor living area w/extended covered patio.Large backyard&LAKEFRONT VIEW.3 Car Garage w/Sub-Zero fridge&built-ins.GE20KW,200 amp generator-entire house.Tomball ISD' ,`Acres` = '0.3607' ,`Area` = '15' ,`BuilderName` = 'J Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODTRACE 03, BLOCK 1, LOT 8' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '15713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace 03' ,`TaxAmount` = '21449' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649820' WHERE `Matrix_Unique_ID` = '213191130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:29:08.440' ,`MLSNumber` = '42133464' ,`ListAgentFullName` = 'Melissa Lacy' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Kathy Griggs' ,`SellingOfficeName` = 'Griffin Realty & Associates' ,`Latitude` = '29.543550' ,`Longitude` = '-95.216380' ,`PhotoCount` = '17' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '324000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winding' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Road' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Four bedroom, two bath beautifully updated home in FISD. Granite countertops, laminate flooring, and new paint. Oversized backyard with deck that is the perfect spot to enjoy family time. All outdoor accessories including TV are staying with the home. Schedule your showing today and don\'t miss this amazing space to make memories.' ,`Acres` = '0.1931' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 20 PAGE 4 E 66 FT OF LOT 25 BLK 2 VILLAGE GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village Green' ,`TaxAmount` = '4883' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649820' WHERE `Matrix_Unique_ID` = '213303791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:27:17.357' ,`MLSNumber` = '43495287' ,`ListAgentFullName` = 'Perla Navarro' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700065' ,`Longitude` = '-95.206172' ,`PhotoCount` = '38' ,`PostalCode` = '77506' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled home in the Pasadena area. This beautiful home is ready for your family. The home includes New flooring, New roof, and New Central HVAC. The home is ready with all New plumbing inspected by the city of Pasadena. Featuring New updated kitchen cabinets and New ceiling fans. The home has a nice backyard with potential of having an RV or boat in the back yard. Don\'t loose out on coming to check out this fully updated property. Schedule a showing to appreciate!!' ,`Acres` = '0.1391' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 211 & W 10 FT OF LT 212 INLAND HARBOR' ,`LotDesciption` = 'Wooded' ,`LotSize` = '6060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MORALES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inland Harbor' ,`TaxAmount` = '2720' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649820' WHERE `Matrix_Unique_ID` = '213441235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:36:07.897' ,`MLSNumber` = '60850953' ,`ListAgentFullName` = 'Amanda Wilks' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'William Valencia' ,`SellingOfficeName` = 'ME Realty Group LLC' ,`Latitude` = '29.970657' ,`Longitude` = '-95.189390' ,`PhotoCount` = '41' ,`PostalCode` = '77346' ,`RoomCount` = '13' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lake Clark' ,`StreetNumber` = '17411' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLERS! THE ONLY AVAILABLE HOME IN EAGLE SPRINGS FEATURING A MEDIA ROOM, WINE GROTTO, & OUTDOOR KITCHEN W/A FIREPLACE! You can’t beat these features and price. Across the street from the park, rare find! Updates include gray wood like tile flooring, new paint, white quartz counters, plantation shutters, & SS appliances. This former model home is picture perfect with a 2 story limestone fireplace, formal dining, & study. Primary retreat features an exquisitely customized en suite bath with dual vanity, separate shower, soaking tub, & walk in closet! Upstairs you will find an expansive game room, media room with custom designed bar, stage, & cabinets, 3 ample bedrooms, and full bath! Covered back patio overlooks the yard with an outdoor kitchen with a wood-burning fireplace. Close to ASE, Splash Pad, & is zoned to W. Lake Middle! Neighborhood amenities include resort and competition style pools, sports fields, 24hr fitness center, parks & coordinated neighborhood events.' ,`Acres` = '0.1697' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 4 EAGLE SPRINGS SEC 24 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '7984' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649820' WHERE `Matrix_Unique_ID` = '213516388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:31:40.490' ,`MLSNumber` = '39827711' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768032' ,`Longitude` = '-94.933387' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Trailwood' ,`StreetNumber` = '3611' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 3–4-bedroom home on an oversized pool sized backyard in one of Baytown\'s finest neighborhoods. Home features high vaulted ceilings in the living area, completely remodeled bathrooms with finishes (Refer to upgrades list) worthy of a home that is double the price, refinished kitchen cabinets with Misty black honed granite counters, fresh interior and exterior paint, recent roof (2016), HVAC (2017), water heater (2022) and more. Fully fenced backyard that could be ideal for kids and pets to play. Not in a flood zone and never flooded!' ,`Acres` = '0.2514' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 TRAILWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood' ,`TaxAmount` = '5396' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649821' WHERE `Matrix_Unique_ID` = '213814514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:45:11.383' ,`MLSNumber` = '9272867' ,`ListAgentFullName` = 'Rosalva Cardenas' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578974' ,`Longitude` = '-95.373135' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Flower Field' ,`StreetNumber` = '702' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated with great taste! 55+ Community. In Golf course and in a corner lot!. Great location by 288 great access to Medical center & Downtown. Beautiful recently updated home in the desirable active senior community of Country Place. NEW Roof AC in 2019. Very spacious Living Room, Dining, & Primary Bedroom. Kitchen with new granite counters and updated lighting. New Vinyl Plank Flooring throughout home, carpet only in bedrooms. Gate in Backyard for more privacy. Amenities include Olympic size Pool, Hot Tub, Tennis Courts, Golf Course & multitude of Activities at the Clubhouse: Travel Club, Friday Happy Hours at the Grill, Exercise rooms, Library, Game room, Auditorium. 24/7 Manned Security Gate. Easy access to shopping, restaurants, medical facilities, & only a short drive to downtown Houston.' ,`Acres` = '0.1944' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 1 LOT 13' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '8468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '4195' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649821' WHERE `Matrix_Unique_ID` = '213884704' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214213249','1669649821','214213249','2022-11-26T19:26:28.403','35654252','Dwight Johnson','Keller Williams Hou Preferred','','','29.318912','-95.452063','27','77583','9','690000.00','Active','Lakeland','1502','Circle','Rosharon','4','1','4','3606','Single-Family','Your beautiful new construction, custom home in The Oaks of Sun Creek Estates is 3600 sq. ft. of beautiful craftsmanship beginning with the 8 ft glass front entry door. Your 3 car garage leads into a mud room/half bath and just inside the entry is an en-suite guest bedroom with the builder\'s signature, spacious, custom walk in closets, all built onsite. This type of onsite, built-in cabinetry will be found throughout this home including the kitchen, dining room and living area. Family dinners and weekend brunches are a dream come true in your spacious kitchen with large marble island, 5 burner stovetop, a pot filler faucet and a spacious, custom walk in pantry! Need we mention the tons of counter space? Your primary suite is a delight with its double walk in closet, double sinks, garden tub and large walk in shower. Entertainment is a breeze with your bonus space and your Texas sized covered outdoor patio and your own pond. Contact me today, don\'t let this one get away.','1.008','5','Abel Nava/Hurta Home','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Rosharon','Propane','1','THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 1 L','Cleared,Subdivision Lot,Water View','43908','Appraisal District','','475','1','Never Lived In','3','','0','','','','','Composition','5 - Angleton','FRONTIER ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Vacant/Unoccupied','Builder','1','Ranch,Traditional','The Oaks At Suncreek Estates','1561','1.986','Aerobic,Septic Tank','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:44:20.047' ,`MLSNumber` = '21948988' ,`ListAgentFullName` = 'Laurie Lujan' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = 'Hong Van' ,`SellingOfficeName` = 'Aimpro Realty & Management LLC' ,`Latitude` = '29.693010' ,`Longitude` = '-95.684655' ,`PhotoCount` = '20' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '157500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pastoria' ,`StreetNumber` = '17016' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious duplex in award wining Fort Bend ISD Home is priced below market due to it needs some updating in bathrooms and Kitchen AC 6 years old NO Carpet large living room GAS Stove 2019 Refrigerator 6 years old large enclosed Patio has a window unit Would make a nice game room or office. 3rd bedroom entrance is only from inside of Primary bedroom so could be a office/study or Nursery .' ,`Acres` = '0.0972' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION WEST SEC 2, BLOCK 2, LOT 12-A (SW 1/2)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission West Sec 2' ,`TaxAmount` = '2619' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649821' WHERE `Matrix_Unique_ID` = '214221777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:20:15.450' ,`MLSNumber` = '5905490' ,`ListAgentFullName` = 'Joe Hernandez' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779381' ,`Longitude` = '-95.353954' ,`PhotoCount` = '22' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapman' ,`StreetNumber` = '1917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bedroom, 2 bath home (plus office) is ready for move in! This stunning home was recently remodeled in 2020. It has a spacious and fully remodeled kitchen, equipped with stainless steel appliances, farmhouse sink and quartz countertops. The property is completely fenced with an electric gate and a cozy front porch. The open floor plan makes it excellent for hosting guests or entertaining family. Did we mention location? It is within a few minutes drive of both I-45 and I-10 and is conveniently located just a few minutes from downtown, the Heights and Midtown. Within immediate area, you will find coffee shops, restaurants, Metro Rail, Minute Park and U of H Downtown.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 10 & 11 BLK 6 CASCARA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cascara' ,`TaxAmount` = '4338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649821' WHERE `Matrix_Unique_ID` = '214222645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:33:39.933' ,`MLSNumber` = '70901555' ,`ListAgentFullName` = 'Yadira Ornelas' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864211' ,`Longitude` = '-95.190032' ,`PhotoCount` = '13' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Wyatt Oak' ,`StreetNumber` = '9522' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a Cozy modern/traditional home. It is a 3 bedroom, 2 bath, 2 car garage! Relax in your primary suite with a walk-in closet included and space for a sitting area. Ceramic tile throughout the home, fresh interior paint, lots of natural light. new window treatments, light fixture, plumbing fixtures and much more. Located nearby shopping and dining. Easy access to Beltway 8, Hwy 59, I-10, and Hwy 90! Call me for your private tour or any questions. Tiene preguntas sobre estate casa llame hoy y le podemos dar una cita para ver y mostrar la casa.\r\n*Professional pictures coming soon' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 SUNRISE PINES SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunrise Pines Sec 01' ,`TaxAmount` = '4781' ,`TaxRate` = '2.9993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649822' WHERE `Matrix_Unique_ID` = '214692459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T19:59:58.640' ,`MLSNumber` = '77967422' ,`ListAgentFullName` = 'Chelsea Boone' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Jackeline Mateos' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '29.854387' ,`Longitude` = '-95.252903' ,`PhotoCount` = '15' ,`PostalCode` = '77078' ,`RoomCount` = '4' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sterlingshire' ,`StreetNumber` = '9303' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the one you’ve been searching for! Completely remodeled 4 bedroom 2 bathroom home! As soon as you walk in you are greeted with a gorgeous luxury kitchen. The bathrooms are completely remodeled luxury style bathrooms that have all new cabinets and vanities, luxury fixtures and countertops! This home also has a brand new HVAC, garage door, new paint, new windows and tile flooring throughout. This is the perfect turnkey property for you to call home! Schedule your showing today!' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 46 BLK 4 WOOD GLEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Glen Sec 02' ,`TaxAmount` = '2585' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649822' WHERE `Matrix_Unique_ID` = '214803384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:58:11.930' ,`MLSNumber` = '75597441' ,`ListAgentFullName` = 'Christopher Easley' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930722' ,`Longitude` = '-95.238883' ,`PhotoCount` = '26' ,`PostalCode` = '77396' ,`RoomCount` = '3' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Long' ,`StreetNumber` = '14823' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1391' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 FALL CREEK EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fall Crk East Sec 1' ,`TaxAmount` = '8348' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649822' WHERE `Matrix_Unique_ID` = '214831940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T20:09:56.477' ,`MLSNumber` = '60149949' ,`ListAgentFullName` = 'Cindy Kipling' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492741' ,`Longitude` = '-95.141582' ,`PhotoCount` = '24' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Morley Point' ,`StreetNumber` = '4511' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific One Story home located on Cul-de-sac in great community! Home has a large back yard with flagstone pavers to extend the covered patio. Upon entering you will notice the art niche in foyer flanked by the study on the right and the formal dining on the left with crown molding in both rooms and foyer. High 10 ft ceiling throughout. Large kitchen that overlooks the den with a gas log stone cast fireplace. From the den you will enter the private bedrooms with a game room separating the primary suite and the other two bedrooms. Large primary bathroom with his and her sinks with a large vanity, a large walk in closet and a great soaking tub and separate shower. Another closet in the primary suite as well. Fresh interior paint throughout, new ac and heat inside and out, newer water heater. NO MUD TAX IN THIS NEIGHBORHOOD! Hurry to make this home your own!' ,`Acres` = '0.2281' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR VILLAGES OF OAK CREEK COLONY (99), BL' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Oak Creek Colony' ,`TaxAmount` = '6547' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649822' WHERE `Matrix_Unique_ID` = '214902823' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215018005','1669649823','215018005','2022-11-26T20:15:10.743','85341281','Janelle Williams','RE/MAX Cinco Ranch','','','29.705345','-95.872916','39','77441','5','395000.00','Active','Hickory Manor','29011','Lane','Fulshear','2','0','2','1892','Single-Family','Popular \"Sablewood\" plan features an open concept layout with an oversized Kitchen (+ island) for entertaining. GE Stainless Appliances. Open & airy living room with cozy gas log fireplace. Flex Space easily converts to home office, den or gym. Primary Bedroom with Bay Windows. Spacious Secondary Bedroom & Bath (w/ full size linen closet) on opposite side of home. Elegant Shutters. Hunter Ceiling Fans. Original owner has taken meticulous care of this home. Stairs lead to 460 sf \"Texas Basement\" for additional storage but can also be finished out. Extra Large Covered Back Patio (plumbed for gas). 2 Car Garage with Epoxy Floor. All Brick Home with full gutters. Tankless Water Heater. Water Softener. Bonterra is a master planned community designed for todays active 55+ adults. The community offers activities planned by a professional lifestyle director! Amenities include a 10,000 sf clubhouse with fitness center, spa, gameroom, lagoon style pool, pickleball courts and more! Live it Up!','0.137','30','Taylor Morrison','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','BONTERRA AT CROSS CREEK RANCH SEC 5, BLOCK 1, LOT 7','Subdivision Lot','5969','Appraisal District','','2925','0','','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Supra Keybox','Appraisal District','1','Traditional','Bonterra at Cross Creek Ranch','10778','3.3362','Water District','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215048041','1669649823','215048041','2022-11-26T19:23:37.387','70030984','Noor Hassan','Apex Brokerage, LLC','','','29.791566','-94.954445','29','77521','3','500000.00','Active','Archer','905','Road','Baytown','2','0','3','2016','Single-Family','Looking for a Ranch Style Home thats close to nature and the city? Well this 6 Acre Property is it! This Gorgeous 3 Bedroom/2 Bath 2016 Sq. foot Home is Located off Archer Rd. A great place for tenants that need to store cars, RVs, horses or cattle!\n\n Your own Country Oasis but just 5 minutes from town and amenities/schools. Large Spacious Yard, has 4 acres fenced in for Horses or Other Farm Animals. Large Fully Functioning Barn with Automatic Watering System. Next to barn are two sheds for storage and covered area for farm equipment. Also has an In-Ground Swimming pool with full decking, storage shed and Pool cabana. This Property comes with it\'s own Septic, Well, Aerobic Watering System, and solar panels to help save you money! \n\nRental qualifications are income 3x rent, and good credit! ','6.12','2','','','Electric Dryer Connections','','No Disclosures','','','','Baytown/Harris County','Butane','0','TRS 3H & 3-I ABST 683 W RITCHIE','Cleared','266587','Appraisal District','','','0','','6','Electric Oven','1','In Ground','','Electric Cooktop','','Slate','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Barndominium','2067','','','Septic Tank','2002','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215079693','1669649823','215079693','2022-11-26T19:03:29.387','54187859','Ingrid Philipson','Bellaire Fine Properties','','','29.743194','-95.612180','44','77077','9','399456.00','Active','Paso Rello','2118','Drive','Houston','2','1','4','2628','Single-Family','Stunning Home - A Side Front Porch Welcomes YOU to Spacious Elegant Foyer – Entryway w. Very High Ceilings w. Staircase leading to All Bedrooms Up - To the Right, Private Living Room w vaulted tray ceiling, 7 windows, Wood Oak Floor, Marble hearth by Gas Log Fireplace. – To the Left, Dining Room open to Den w Dramatic Stone Fireplace. - Open to Breakfast Room Open to Kitchen. – Kitchen w Stunning Granite Countertops & Stunning Slate Backsplash – Gas Stove – Double Oven – Truly the Kitchen for those who Love to cook & Entertain! - Large Master Suite w/2 sided Fireplace facing the Spacious Dramatic Master Bath w Super High Ceiling w Skylight above the Whirlpool - Travertine Shower – Antique cabinets sinks. – Three Bedrooms plus One Loft w. Closet – Extra Storage Space throughout & in Attic – Covered Back Patio – Storage Shed – Crape Myrtles – Jasmin - Sprinkler System – Come see this showcase home for yourself - Master Bedroom will have New flooring placed before closing. NEVER FLOODED.','0.1148','31','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','3','Energy Corridor','Central Gas','1','LT 27 BLK 1 BRIAR WOOD SEC 1','Subdivision Lot','5000','Appraisal District','','552','0','','2','Double Oven','0','','','Gas Cooktop','','Composition','27 - Houston','DAILY ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern','Briar Wood Sec 01','6293','2.3307','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215089124','1669649823','215089124','2022-11-26T19:37:30.823','58417264','Steven Collier','BHGRE Gary Greene','','','30.403243','-95.666407','40','77356','10','1069000.00','Active','Renaissance','11618','Drive','Montgomery','4','0','5','4049','Single-Family','AMAZING WATERFRONT property on just over 1/2 ACRE located on The Island in Grand Harbor and that is just a short boat ride to MARGARITAVILLE or OPEN WATER!! BACKYARD PARADISE with ample patio space, OUTDOOR KITCHEN, and heated pool/spa. This home is a 5 bed, 4-bath home with a 3-car garage. Open concept home featuring transitional style kitchen, MASSIVE QUARTZ ISLAND, upgraded finishes, and perfect for entertaining! The family room has a sliding glass door that leads out to the pool area, perfect for indoor/outdoor entertaining. The primary bedroom has a view of the lake - an oversized shower, a large soaking tub, dual vanities with plenty of storage. The primary closet leads to the laundry room. HIGH-END finishes include plantation shutters, Generac GENERATOR, and extensive concrete around the pool, house, and to the boat dock. DON\'T MISS THIS OPPORTUNITY FOR A LIKE-NEW HOME with LOTS OF UPGRADES! Highly acclaimed Montgomery ISD.','0.5452','39','','','','','No Disclosures','1','Gas Connections,Wood Burning Fireplace','1','Lake Conroe Area','Central Gas','1','S616400 - THE ISLAND AT GRAND HARBOR, BLOCK 1, LOT 10, ACRES','Waterfront','23751','Appraisal District','','1200','0','','3','Electric Oven','1','Heated,In Ground','','Gas Cooktop','','Tile','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Contemporary/Modern,Traditional','Grand Harbor','14395','1.8242','Public Water,Septic Tank','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215089674','1669649823','215089674','2022-11-26T20:56:16.657','72255301','DJ Arsenault','Texan Realtors.com, LLC','','','30.136040','-95.380684','33','77386','8','365000.00','Active','Liberty Knoll','31276','Lane','Spring','2','0','4','2016','Single-Family','Beautiful Ranch in highly sought after Falls at Imperial Oaks. Open concept makes home feel large & spacious, perfect for entertaining. Inviting curb appeal & loaded w/ modern upgrades such as, 42\" cabinets, Stainless appliances. SMART house w/ built-in Wi-Fi/ ethernet outlet throughout the house, Techshield reflective roof, double pane windows making it energy efficient & affordable. Kitchen pantry & plenty of storage in the kitchen. Raised 10\' ceilings w/ recessed lighting throughout. Large owner suite & private french door bath w/ walk-in closet. Huge backyard w/ greenbelt view & large covered patio plumbed w/ Gas stub (great for gas grill/ kitchen) & sprinkler system. 1 block to the Retreat pool, splashpad & park. Top CISD schools, Bradley Elementary & Grand Oaks HS. Access to 2 pools, Splash pads, Fitness center/clubhouse & Dog Park. Minutes to The Woodlands, I-45, Grand Parkway, Hardy, Market Street & Downtown Houston via the Grand Parkway. 5 Minutes to the future YMCA.','0.1699','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S504223 - FALLS AT IMPERIAL OAKS 23, BLOCK 2, LOT 28','Greenbelt,Subdivision Lot','7401','Appraisal District','','650','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','BRADLEY ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch,Traditional','Falls At Imperial Oaks 23','','','Public Water,Septic Tank,Water District','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215104540','1669649823','215104540','2022-11-26T19:08:58.990','44785633','Robert Saji','Zameen Realty','','','29.449970','-95.083880','21','77539','6','319000.00','Active','Sawyer Gully','412','Court','Dickinson','2','0','3','2006','Single-Family','You will find this home close to all the amenities your looking for. quick access to the freeway hidden between other neighborhoods. This home has 3 bedroom and 3 full bathrooms. You will notice many wonderful updates throughout the home. An all brick construction is evidence of a well built home. Make an appointment to see it now.','0.1718','33','','','','','Sellers Disclosure','','','','Dickinson','Central Gas','1','BORDEN\'S GULLY (2007) ABST 19, BLOCK 2, LOT 6, ACRES 0.172','Cul-De-Sac','7483','Appraisal District','','250','0','','2','','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Bordens Gully 2007','6834','2.5214','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215104753','1669649823','215104753','2022-11-26T20:26:31.620','53719801','Cynthia Corder','JPAR - The Sears Group','','','29.425521','-95.080998','49','77539','5','682000.00','Active','2nd','12104','Street','Dickinson','2','0','4','2665','Single-Family','This rare modern brick farmhouse is now available! Move in by Christmas! 4 Bdrm 2 Bath home sits on nearly 3acres. Sit in the rockers on the beautiful front porch and enjoy the charming entryway! This open-concept floor plan has an incredible vaulted ceiling w/ beam in the living area, fireplace and builtins & lots of natural light. The chef\'s kitchen has an oversized 8ft island, white quartz countertops, a herringbone backsplash, custom vent hood, smart appliances, and lots of storage in stylish two-tone cabinets. Included is an extra large pantry & utility room. The primary bedroom has a color-changing remote fireplace, barn door, and bath w/a free-standing soaking tub, huge shower w/3 shower heads, and makeup vanity with dbl sinks. The outdoor living area is perfect for backyard parties w/a vaulted ceiling and wood beams, & looks out over your acreage. There is a chicken coop matching the house; fresh eggs! The lot has plenty of room for a pool, horses, a garden & more! Tour now!','2.6605','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Mock Fireplace','2','Santa Fe','Central Gas','0','LOT 2 FULLEN SUB (2019) ABST 1','Cleared,Other','115893','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Barndominium,Ranch,Traditional','Fullen Subdivision','14570','2.4081','Septic Tank,Well','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215105165','1669649823','215105165','2022-11-26T20:19:49.993','81029848','Maria Bonilla','Walzel Properties','','','29.835926','-95.315097','0','77016','5','224116.00','Active','Peachtree','8316','Street','Houston','2','0','3','1350','Single-Family','Large open concept with an oversize lot. This house is price to sell. You dont want to miss out on a home with many upgrades. Call and schedule your showing now \r\nCall and ask about the incentives this house offers','0.2755','2','Europa Home','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Northside','Central Electric','0','LT 1213 BLK 9 TRINITY GARDENS SEC 3','Subdivision Lot','12000','Appraisal District','','','1','To Be Built/Under Construction','0','Electric Oven','0','','','Freestanding Range','','Composition','27 - Houston','COOK ELEMENTARY SCHOOL (HOUSTON)','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Supra Keybox','Builder','1','Traditional','Trinity Gardens Sec 03','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully